Determining the number of buckets in hive

Hi, I know this question might have been beaten to death, but I could not find an answer to a particular question. I'm using hive 0.10.x I have a table partitioned on day and I would like to bucket the table on a different column to avail of the SMB join optimization. I have seen an earlier threa

Re: "desc database extended " doesn't print dbproperties?

Thanks Navis! On Wednesday, 25 June 2014 10:44 PM, Navis류승우 wrote: Booked in https://issues.apache.org/jira/browse/HIVE-7298 Thanks, 2014-06-26 14:28 GMT+09:00 Navis류승우 : Seemed regression of HIVE-6386. Will be fixed in next version. > > > >2014-06-26 7:58 GMT+09:00 Sumit Kumar : > >

Re: DECIMAL precision is too small

Sorry, I meant 128 bit On Jun 26, 2014, at 11:31 AM, Brian Jeltema wrote: > I need to represent an unsigned 64-bit value as a Hive DECIMAL. The current > precision maximum is 38, > which isn’t large enough to represent the high-end of this value. Is there an > alternative? > > Brian >

DECIMAL precision is too small

I need to represent an unsigned 64-bit value as a Hive DECIMAL. The current precision maximum is 38, which isn’t large enough to represent the high-end of this value. Is there an alternative? Brian

Load xml file in avro file format to Hive

Hi All, My task is to load xml file to hive table and access the hive table through Impala. I was able to load xml file to hive table using custom Input Format and access the hive table data, but custom Input Format is not supported in Impala. Now I am trying to achieve this by using 'AvroCont

Error in create table

Hi all, I have set mysql as my metastore but when I try to create a table the follwoing error comes.. FAILED: Error in metadata: MetaException(message:javax.jdo.JDODataStoreException: Insert of object "org.apache.hadoop.hive.metastore.model.MStorageDescriptor@1316bc6e" using statement "INSERT I

Re: Hive metastore error

can u please attach hive-site.xml file. On Thu, Jun 26, 2014 at 2:11 PM, Rishabh Bhardwaj wrote: > HI all, > I have changed my hive metastore to mysql using the steps described here > > http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/4.2.0/CDH4-Installation-Guide/cdh4ig_topi

Re: Hive metastore error

is your hive metastore service running ? On Thu, Jun 26, 2014 at 2:11 PM, Rishabh Bhardwaj wrote: > HI all, > I have changed my hive metastore to mysql using the steps described here > > http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/4.2.0/CDH4-Installation-Guide/cdh4ig_top

Hive metastore error

HI all, I have changed my hive metastore to mysql using the steps described here http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH4/4.2.0/CDH4-Installation-Guide/cdh4ig_topic_18_4.html Now when I am running any hive command on cli like show databases or show tables , It gives m

Re: edit permissions to wiki

Done. Thanks, Nitin for your help in improving Hive wiki! On Tue, Jun 24, 2014 at 12:57 PM, Nitin Pawar wrote: > nitinpawar432