[IMPALA-5508] Impala prints warning messages that it does not have READ_WRITE access to ADLS path even when it does

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 2.9.0
• Component/s: Backend
• Labels: cloud ramp-up
• Epic Color: ghx-label-8
• Assignee: Sailesh Mukil
• Reporter: Mostafa Mokhtar
• Created: 14/Jun/17 21:39
• Updated: 14/Jun/17 21:39

Description

When creating tables on ADLS Impala reports that it doesn't have READ_WRITE to the table location while it actually does

[impala-adls-2:21000] > create table item2 like item location 'adl://foo.azuredatalakestore.net/impala-perf/tpcds3000/item2';
Query: create table item2 like item location 'adl://foo.azuredatalakestore.net/impala-perf/tpcds3000/item2'

WARNINGS: Impala does not have READ_WRITE access to path 'adl://foo.azuredatalakestore.net/impala-perf/tpcds3000'
Fetched 0 row(s) in 1.06s
[impala-adls-2:21000] > insert into item2 select * from item;
Query: insert into item2 select * from item
Query submitted at: 2017-06-14 16:25:51 (Coordinator: http://foo.bar.com:25000)
Query progress can be monitored at: http://foo.bar.com:25000/query_plan?query_id=3842fb82554f8d38:82c590eb00000000
Modified 360000 row(s) in 23.39s
[impala-adls-2:21000] > select count(*) from item2;
Query: select count(*) from item2
Query submitted at: 2017-06-14 16:38:26 (Coordinator: http://foo.bar.com:25000)
Query progress can be monitored at: http://foo.bar:25000/query_plan?query_id=e94e796d091aa6c7:fa3bb68b00000000
+----------+
| count(*) |
+----------+
| 360000   |
+----------+
Fetched 1 row(s) in 4.08s