Hi @Junichi Oda - This is expected behaviour and it is the reason why it is recommended to have all hive processes run as hive user when you secure Hive with ranger. There are two options in order to secure access to hive with Ranger : Solution 1 Use both a repository HDFS and Hive to handle rights Keep "run as end user instead of hive" (hive.server2.enable.doAs=true) This means the dual maintenance that you describe Solution 2 Give rights to the hive user on the /apps/hive/warehouse arborescence in Ranger HDFS repository Lock down filesystem permissions on HDFS (for example, chmod 750) Use the Ranger Hive repository to handle rights on Hive tables Run as hive instead of end user (hive.server2.enable.doAs=false) --- Solution 2 is the way to go. You may be concerned about auditability, but the Hive audits in Ranger will show the correct user. The HDFS audits and the YARN audits will still show "hive" yes, but you will be able to tell who ran the query. ... View more

EDIT: oops - just read the end bit of your post... still try to do it in the shell action itself and see? --- I believe this is a known limitation in non-secure clusters, whereby the containers are running as YARN user and not running as user xyz. Try to pass in the HADOOP_USER_NAME variable as illustrated below: $ `export HADOOP_USER_NAME=xyz ; hive -hiveconf hive.execution.engine=mr -e 'show databases' ` ... View more

According to this Hive Language documentation, you can achieve the same thing using regular expressions: A SELECT statement can take regex-based column specification in Hive releases prior to 0.13.0, or in 0.13.0 and later releases if the configuration property hive.support.quoted.identifiers is set to none. * We use Java regex syntax. Try http://www.fileformat.info/tool/regex.htm for testing purposes. * The following query selects all columns except ds and hr. SELECT `(ds|hr)?+.+` FROM sales ... View more

Hi @Bhupendra Mishra You don't need the --table argument - it's only relevant for imports and exports (not eval). Try this: sqoop eval --connect jdbc:mysql://localhost.localdomain/sqoop_test --username root --query "SELECT * FROM emp" ... View more