Re: hive query plain has not index description

2017-01-19 Thread min zou
it's fixed, as the params were not work. 2017-01-19 17:34 GMT+08:00 min zou : > hi, i have created a table hive_hbase_visitor2 in hive, and created an > index on the table,but when i execute the query plan about *select ** from > hive_hbase_visitor2 where name='knlf', the description of index wa

how to customize tez query app name

2017-01-19 Thread Frank Luo
When running tez query, the “Applications” page shows the job as “HIVE-9c5a8bf1-911b-427a-8d16” for example, which is not helpful, especially when a ton of jobs running at the same time. So is there any way to customize the app name? “mapreduce.job.name” works for M/R queries, not Tez. Thx!

Re: hplsql tool not supporting NON EQUI JOIN

2017-01-19 Thread Dmitry Tolpeko
Prabhu, Can you please post the statement? Dmitry On Thu, Jan 19, 2017 at 7:38 PM, wrote: > Hi there, > > This is Prabhu Sekar from Cognizant UK. > We are working on an initiative where in we need to migrate 100+ complex > stored procedures from SQL to Hive. > While researching, we came across

Re: Hive JDBC with ZooKeeper Discovery and Kerberos Principal

2017-01-19 Thread hadoop hive
Did you tried jdbc:hive2:///;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver;principal=hive/_h...@example.com;transportMode=http;httpPath=cliservice On 18 Jan 2017, 12:40 PM +0800, Amin Abbaspour , wrote: > > Hi, > > > In case of HA JDBC connectivity to multiple Hive servers with Zo

hive query plain has not index description

2017-01-19 Thread min zou
hi, i have created a table hive_hbase_visitor2 in hive, and created an index on the table,but when i execute the query plan about *select ** from hive_hbase_visitor2 where name='knlf', the description of index was not found, did the index not succeed? *create index hive_hbase_visitor2_index on t