Some Questions about Hive Index

create index x on my_table(my_function_1(col1, col2, ...), my_function_2(col1, col2, ...), ...)? 3. If we try to use the non-indexed columns in base table, can we use the index table to speed up the query? join? Any suggestions? Thanks in advance. Best wishes, Lin

About Hive Index

emantic analysis: No partition predicate found for Alias "A_IX" Table "A_IX" FAILED: Hive Internal Error: java.lang.NullPointerException(null). Any suggestions? Thanks. Best wishes, Lin

Re: About Hive Index

Hi Phil, It works. Thanks a lot. Best wishes, Lin On Tue, Aug 21, 2012 at 11:49 PM, Philip Tromans wrote: > There's a case bug in hive. Put all the names into lower case. I've got a > JIRA open about it somewhere. > > Phil. > On Aug 22, 2012 4:39 AM, "Lin&quo

How to make hive run multiple queries simultaneously?

Hi, all, I'm running Hive-0.9.0-cdh4.1.2 on a cluster consisting of 3 nodes, I was wondering if I would like to run multiple queries simultaneously? BTW, I have set "hive.exec.parallel" to true in hive-site.xml, but it doesn't work. Thanks. -- Lin Yang

samples for JDBC to connect and query Hive?

Hello Hive masters, I am new to Hive and wondering if any good samples to refer to of using JDBC to connect and query Hive? Thanks. regards, Lin

Re: samples for JDBC to connect and query Hive?

Thanks Prasad! Have a good weekend. regards, Lin On Fri, Mar 27, 2015 at 2:37 PM, Prasad Mujumdar wrote: > Hi Lin, > > Checkout > https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients#HiveServer2Clients-JDBCClientSampleCode > > thanks > Prasad > >

Metastore client initial failed, connection refused

Hi, I am using HCatalog in HUE to import table from a file, and the table had been created successfully. However, when I browser data, there is no any records in that table. I find there are several logs about HiveMetaStoreClient initiation failed and thrift connection refused. Here is the entir

Re: Metastore client initial failed, connection refused

ot be understood as given or endorsed by Peridale Ltd, its > subsidiaries or their employees, unless expressly so stated. It is the > responsibility of the recipient to ensure that this email is virus free, > therefore neither Peridale Ltd, its subsidiaries nor their employees accept >

Hive 4.0.0-alpha-2 + Hadoop 3.3.1. Can't start beeline. Need help

I downloaded Hive 4.0.0-alpha-2 tar.gz and install along with with Hadoop 3.3 on Ubuntu 22.04. I followed the instruction in the “Getting started guide” till running HiveServer2 and Beeline (https://cwiki.apache.org/confluence/display/Hive//GettingStarted#GettingStarted-RunningHiveServer2andBee

Re: Hive 4.0.0-alpha-2 + Hadoop 3.3.1. Can't start beeline. Need help

= cf7b52e0-37f1-4323-a625-c44229b60d6b Does hiveserver2 have some detail log somewhere else? Thanks. > On Jan 3, 2023, at 8:21 PM, Naveen Gangam wrote: > > Hi Jon, > Could you please attach the full hiveserver logfile please? > > Thank you > > On Tue, Jan 3, 2023 at 1

Re: Issue related to apache hive 3.1.3

Unsubscribe > On Mar 29, 2023, at 1:06 AM, Ayush Saxena wrote: > > Hi Omkar, > > If Impala has some issues, you should reach to Impala mailing lists > > -Ayush > >> On 29-Mar-2023, at 1:13 PM, Omkar Rohadkar >> wrote: >> >>  >> Hi team, >> >> We are using apache hive 3.1.3 and we are usi