[ 
https://issues.apache.org/jira/browse/IMPALA-9270?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Fang-Yu Rao updated IMPALA-9270:
--------------------------------
    Description: 
Impala is not able to list the tables under the specified database when we log 
in to the Impala shell as the user $USER. Specifically, this phenomenon could 
be reproduced by the following steps.
 # Execute "{{$IMPALA_HOME/bin/start-impala-cluster.py --kill}}"
 # Execute the following to start a Ranger-enabled Impala miniculster
{code:java}
$IMPALA_HOME/bin/start-impala-cluster.py \
--cluster_size=3 \
--num_coordinators=3 \
--log_dir=/tmp/ \
--log_level=1 \
'--state_store_args=--statestore_update_frequency_ms=50 
--statestore_priority_update_frequency_ms=50 
--statestore_heartbeat_frequency_ms=50' \
'--impalad_args=--server-name=server1 --ranger_service_type=hive 
--ranger_app_id=impala --authorization_provider=ranger' \
'--catalogd_args=--server-name=server1 --ranger_service_type=hive 
--ranger_app_id=impala --authorization_provider=ranger'
{code}
 # Log in to the Impala shell via "{{$IMPALA_HOME/bin/impala-shell.sh}}" (as 
the user {{$USER}} by default)
 # In the Impala shell, execute "{{use functional;}}"
 # In the Impala shell, execute "{{show tables;}}"

No table will be displayed after executing "{{show tables;}}" above. On the 
other hand, if we in Step 3 above log in to the Impala shell as the 
administrator, i.e., by executing "{{$IMPALA_HOME/bin/impala-shell.sh -u 
admin}}", we will be able to see the list of tables under the specified 
database (the database {{functional}} in this case).

 

  was:
Impala is not able to list the tables under the specified database when we log 
in to the Impala shell as the user $USER. Specifically, this phenomenon could 
be reproduced by the following steps.
 # Execute "{{$IMPALA_HOME/bin/start-impala-cluster.py --kill}}"
 # Execute the following to start a Ranger-enabled Impala miniculster
{code:java}
$IMPALA_HOME/bin/start-impala-cluster.py \
--cluster_size=3 \
--num_coordinators=3 \
--log_dir=/tmp/ \
--log_level=1 \
'--state_store_args=--statestore_update_frequency_ms=50 
--statestore_priority_update_frequency_ms=50 
--statestore_heartbeat_frequency_ms=50' \
'--impalad_args=--server-name=server1 --ranger_service_type=hive 
--ranger_app_id=impala --authorization_provider=ranger' \
'--catalogd_args=--server-name=server1 --ranger_service_type=hive 
--ranger_app_id=impala --authorization_provider=ranger'
{code}

 # Log in to the Impala shell via "{{$IMPALA_HOME/bin/impala-shell.sh}}" (as 
the user {{$USER}} by default)
 # In the Impala shell, execute "{{use functional;}}"
 # In the Impala shell, execute "{{show tables;}}"

No table will be displayed after executing "{{show tables;}}" above. On the 
other hand, if we in Step 3 above log in to the Impala shell as the 
administrator, i.e., by executing "{{$IMPALA_HOME/bin/impala-shell.sh -u 
admin}}", we will be able to see the list of tables under the specified 
database (the database {{functional}} in this case).

 


> Impala is not able to list the tables when the logged in user is $USER
> ----------------------------------------------------------------------
>
>                 Key: IMPALA-9270
>                 URL: https://issues.apache.org/jira/browse/IMPALA-9270
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Frontend
>            Reporter: Fang-Yu Rao
>            Assignee: Fang-Yu Rao
>            Priority: Major
>
> Impala is not able to list the tables under the specified database when we 
> log in to the Impala shell as the user $USER. Specifically, this phenomenon 
> could be reproduced by the following steps.
>  # Execute "{{$IMPALA_HOME/bin/start-impala-cluster.py --kill}}"
>  # Execute the following to start a Ranger-enabled Impala miniculster
> {code:java}
> $IMPALA_HOME/bin/start-impala-cluster.py \
> --cluster_size=3 \
> --num_coordinators=3 \
> --log_dir=/tmp/ \
> --log_level=1 \
> '--state_store_args=--statestore_update_frequency_ms=50 
> --statestore_priority_update_frequency_ms=50 
> --statestore_heartbeat_frequency_ms=50' \
> '--impalad_args=--server-name=server1 --ranger_service_type=hive 
> --ranger_app_id=impala --authorization_provider=ranger' \
> '--catalogd_args=--server-name=server1 --ranger_service_type=hive 
> --ranger_app_id=impala --authorization_provider=ranger'
> {code}
>  # Log in to the Impala shell via "{{$IMPALA_HOME/bin/impala-shell.sh}}" (as 
> the user {{$USER}} by default)
>  # In the Impala shell, execute "{{use functional;}}"
>  # In the Impala shell, execute "{{show tables;}}"
> No table will be displayed after executing "{{show tables;}}" above. On the 
> other hand, if we in Step 3 above log in to the Impala shell as the 
> administrator, i.e., by executing "{{$IMPALA_HOME/bin/impala-shell.sh -u 
> admin}}", we will be able to see the list of tables under the specified 
> database (the database {{functional}} in this case).
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to