RE: DISTRIBUTE BY question

2015-07-13 Thread Ryan Harris
this should get you on the right path: https://issues.apache.org/jira/browse/HIVE-7121 From: Connell Donaghy [mailto:cdona...@pinterest.com] Sent: Monday, July 13, 2015 2:50 PM To: user@hive.apache.org Subject: DISTRIBUTE BY question Hey! I'm trying to write a tool which uses a storagehandler to

DISTRIBUTE BY question

2015-07-13 Thread Connell Donaghy
Hey! I'm trying to write a tool which uses a storagehandler to store HFiles, using a specific partition function. So in order to do this, I have been trying to use DISTRIBUTE BY and a UDF using the key column and number of reducers (which becomes number of partitions, as each reducer creates its ow

Re: Hive metastore using Oracle

2015-07-13 Thread Jason Dere
Looks like it's having trouble with the hive.exec.local.scratchdir setting (which defaults to "${system:java.io.tmpdir}/${system:user.name}"). Is variable substitution disabled (hive.variable.substitute)? You might want to try explicitly setting hive.exec.local.scratchdir when running on the co

Hive metastore using Oracle

2015-07-13 Thread Garry Chen
Hi All, I am trying to setup a remote metastore for Hive using Oracle. The following is my steps and error message when try to start hive. Please help and thank you very much. Garry 1. Create a hive user in Oracle instance 2. Run hive-schema-0.14.0.oracle.sql as