Re: Cross join/cartesian product explanation

2015-11-09 Thread Rory Sawyer
Hi Gopal, Thanks for the speedy response! A follow-up question though: 10Mb input sounds like that would work for a map join. I’m having trouble doing a cross join between two tables that are too big for a map-side join. Trying to break down one table into small enough partitions and then

Fwd: Failed to create HiveMetaStoreClient object in proxy user with Kerberos enabled

2015-11-09 Thread Bing Li
Hi, I wrote a Java client to talk with HiveMetaStore. (Hive 1.2.0) But found that it can't new a HiveMetaStoreClient object successfully via a proxy using in Kerberos env. === 15/10/13 00:14:38 ERROR transport.TSaslTransport: SASL negotiation failure

thrift.TApplicationException: Invalid method name: 'execute'

2015-11-09 Thread Rajkumar Singh
I am trying to get the query result from thrift api using a java program which use thrifthive client to execute a query but I am getting exception org.apache.thrift.TApplicationException: Invalid method name: 'execute' at

Re: query orc file by hive

2015-11-09 Thread Elliot West
Hi, You can create a table and point the location property to the folder containing your ORC file: CREATE EXTERNAL TABLE orc_table ( ) STORED AS ORC LOCATION '/hdfs/folder/containing/orc/file' ;

query orc file by hive

2015-11-09 Thread patcharee
Hi, How can I query an orc file (*.orc) by Hive? This orc file is created by other apps, like spark, mr. Thanks, Patcharee