[root@cn033 ~]# beeline Beeline version 1.3.0-SNAPSHOT by Apache Hive beeline> !connect jdbc:hive2://cn033.l42scl.hortonworks.com:10001/;principal=hive/cn033.l42scl.hortonworks.com@EXAMPLE.COM;ssl=false?hive.server2.transport.mode=http;hive.server2.thrift.http.path=cliservice Connecting to jdbc:hive2://cn033.l42scl.hortonworks.com:10001/;principal=hive/cn033.l42scl.hortonworks.com@EXAMPLE.COM;ssl=false?hive.server2.transport.mode=http;hive.server2.thrift.http.path=cliservice Enter username for jdbc:hive2://cn033.l42scl.hortonworks.com:10001/;principal=hive/cn033.l42scl.hortonworks.com@EXAMPLE.COM;ssl=false?hive.server2.transport.mode=http;hive.server2.thrift.http.path=cliservice: rahman Enter password for jdbc:hive2://cn033.l42scl.hortonworks.com:10001/;principal=hive/cn033.l42scl.hortonworks.com@EXAMPLE.COM;ssl=false?hive.server2.transport.mode=http;hive.server2.thrift.http.path=cliservice: ****** 15/05/26 16:20:04 [main]: WARN jdbc.Utils: ***** JDBC param deprecation ***** 15/05/26 16:20:04 [main]: WARN jdbc.Utils: The use of hive.server2.transport.mode is deprecated. 15/05/26 16:20:04 [main]: WARN jdbc.Utils: Please use transportMode like so: jdbc:hive2://:/dbName;transportMode= 15/05/26 16:20:04 [main]: WARN jdbc.Utils: ***** JDBC param deprecation ***** 15/05/26 16:20:04 [main]: WARN jdbc.Utils: The use of hive.server2.thrift.http.path is deprecated. 15/05/26 16:20:04 [main]: WARN jdbc.Utils: Please use httpPath like so: jdbc:hive2://:/dbName;httpPath= Connected to: Apache Hive (version 1.3.0-SNAPSHOT) Driver: Hive JDBC (version 1.3.0-SNAPSHOT) Transaction isolation: TRANSACTION_REPEATABLE_READ 0: jdbc:hive2://cn033.l42scl.hortonworks.com:> CREATE TABLE permtest_1 (field1 int); No rows affected (9.334 seconds) 0: jdbc:hive2://cn033.l42scl.hortonworks.com:> show create table permtest_1; +------------------------------------------------------------------------------+--+ | createtab_stmt | +------------------------------------------------------------------------------+--+ | CREATE TABLE `permtest_1`( | | `field1` int) | | ROW FORMAT SERDE | | 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' | | STORED AS INPUTFORMAT | | 'org.apache.hadoop.mapred.TextInputFormat' | | OUTPUTFORMAT | | 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' | | LOCATION | | 'hdfs://cn030.l42scl.hortonworks.com:8020/apps/hive/warehouse/permtest_1' | | TBLPROPERTIES ( | | 'transient_lastDdlTime'='1432682432') | +------------------------------------------------------------------------------+--+ 12 rows selected (1.867 seconds) 0: jdbc:hive2://cn033.l42scl.hortonworks.com:> quit 0: jdbc:hive2://cn033.l42scl.hortonworks.com:> [root@cn033 ~]# [root@cn033 ~]# hadoop fs -ls /apps/hive/warehouse/permtest_1 [root@cn033 ~]# hadoop fs -ls /apps/hive/warehouse Found 5 items drwxr-xr-x - hive hdfs 0 2015-04-12 11:44 /apps/hive/warehouse/ahuh.db drwxr-xr-x - hive hdfs 0 2015-04-12 11:12 /apps/hive/warehouse/hdfs_audit drwxr-xr-x - hive hdfs 0 2015-04-11 23:32 /apps/hive/warehouse/lsr drwxrwxrwx - rahman hdfs 0 2015-05-26 16:10 /apps/hive/warehouse/permtest drwxrwxrwx - rahman hdfs 0 2015-05-26 16:20 /apps/hive/warehouse/permtest_1 [root@cn033 ~]# klist Ticket cache: FILE:/tmp/krb5cc_0 Default principal: rahman/cn033.l42scl.hortonworks.com@EXAMPLE.COM Valid starting Expires Service principal 05/26/15 15:51:55 05/27/15 15:51:55 krbtgt/EXAMPLE.COM@EXAMPLE.COM renew until 05/26/15 15:51:55 # Prove auth to local works. [root@cn033 ~]# hadoop org.apache.hadoop.security.HadoopKerberosName rahman/cn033.l42scl.hortonworks.com@EXAMPLE.COM Name: rahman/cn033.l42scl.hortonworks.com@EXAMPLE.COM to rlocal [root@cn033 ~]# beeline Beeline version 1.3.0-SNAPSHOT by Apache Hive beeline> !connect jdbc:hive2://cn033.l42scl.hortonworks.com:10001/;principal=hive/cn033.l42scl.hortonworks.com@EXAMPLE.COM;ssl=false?hive.server2.transport.mode=http;hive.server2.thrift.http.path=cliservice Connecting to jdbc:hive2://cn033.l42scl.hortonworks.com:10001/;principal=hive/cn033.l42scl.hortonworks.com@EXAMPLE.COM;ssl=false?hive.server2.transport.mode=http;hive.server2.thrift.http.path=cliservice Enter username for jdbc:hive2://cn033.l42scl.hortonworks.com:10001/;principal=hive/cn033.l42scl.hortonworks.com@EXAMPLE.COM;ssl=false?hive.server2.transport.mode=http;hive.server2.thrift.http.path=cliservice: rahman Enter password for jdbc:hive2://cn033.l42scl.hortonworks.com:10001/;principal=hive/cn033.l42scl.hortonworks.com@EXAMPLE.COM;ssl=false?hive.server2.transport.mode=http;hive.server2.thrift.http.path=cliservice: ****** 15/05/26 18:03:48 [main]: WARN jdbc.Utils: ***** JDBC param deprecation ***** 15/05/26 18:03:48 [main]: WARN jdbc.Utils: The use of hive.server2.transport.mode is deprecated. 15/05/26 18:03:48 [main]: WARN jdbc.Utils: Please use transportMode like so: jdbc:hive2://:/dbName;transportMode= 15/05/26 18:03:48 [main]: WARN jdbc.Utils: ***** JDBC param deprecation ***** 15/05/26 18:03:48 [main]: WARN jdbc.Utils: The use of hive.server2.thrift.http.path is deprecated. 15/05/26 18:03:48 [main]: WARN jdbc.Utils: Please use httpPath like so: jdbc:hive2://:/dbName;httpPath= Connected to: Apache Hive (version 1.3.0-SNAPSHOT) Driver: Hive JDBC (version 1.3.0-SNAPSHOT) Transaction isolation: TRANSACTION_REPEATABLE_READ 0: jdbc:hive2://cn033.l42scl.hortonworks.com:> show create table permtest_auth_local; Error: Error while compiling statement: FAILED: SemanticException [Error 10001]: Table not found permtest_auth_local (state=42S02,code=10001) 0: jdbc:hive2://cn033.l42scl.hortonworks.com:> create table permtest_auth_local; Error: Error while compiling statement: FAILED: SemanticException [Error 10043]: Either list of columns or a custom serializer should be specified (state=42000,code=10043) 0: jdbc:hive2://cn033.l42scl.hortonworks.com:> CREATE TABLE permtest_auth_local (field1 int); No rows affected (4.558 seconds) 0: jdbc:hive2://cn033.l42scl.hortonworks.com:> create table permtest_auth_local; Error: Error while compiling statement: FAILED: SemanticException [Error 10043]: Either list of columns or a custom serializer should be specified (state=42000,code=10043) 0: jdbc:hive2://cn033.l42scl.hortonworks.com:> show create table permtest_auth_local; +---------------------------------------------------------------------------------------+--+ | createtab_stmt | +---------------------------------------------------------------------------------------+--+ | CREATE TABLE `permtest_auth_local`( | | `field1` int) | | ROW FORMAT SERDE | | 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' | | STORED AS INPUTFORMAT | | 'org.apache.hadoop.mapred.TextInputFormat' | | OUTPUTFORMAT | | 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' | | LOCATION | | 'hdfs://cn030.l42scl.hortonworks.com:8020/apps/hive/warehouse/permtest_auth_local' | | TBLPROPERTIES ( | | 'transient_lastDdlTime'='1432688681') | +---------------------------------------------------------------------------------------+--+ 12 rows selected (1.796 seconds) 0: jdbc:hive2://cn033.l42scl.hortonworks.com:> quit # Shows now it is using it 0: jdbc:hive2://cn033.l42scl.hortonworks.com:> h[root@cn033 ~]# hadoop fs -ls /apps/hive/warehouse/ Found 6 items drwxr-xr-x - hive hdfs 0 2015-04-12 11:44 /apps/hive/warehouse/ahuh.db drwxr-xr-x - hive hdfs 0 2015-04-12 11:12 /apps/hive/warehouse/hdfs_audit drwxr-xr-x - hive hdfs 0 2015-04-11 23:32 /apps/hive/warehouse/lsr drwxrwxrwx - rahman hdfs 0 2015-05-26 16:10 /apps/hive/warehouse/permtest drwxrwxrwx - rahman hdfs 0 2015-05-26 16:20 /apps/hive/warehouse/permtest_1 drwxrwxrwx - rlocal hdfs 0 2015-05-26 18:04 /apps/hive/warehouse/permtest_auth_local