Re: Hive on Oracle

Hi Raj Which jar depends on what version of oracle you are using? The jar version corresponding to each oracle release would be there in oracle documentations online. JDBC Jars should be available from the oracle website for free download. Regards Bejoy KS Sent from remote device, Please ex

Re: Hive on Oracle

Thanks for the reply. Can you specify whether which jar file need need to be used ? where can i get the jar file? does oracle provide one for free? let me know please. Thanks, Raj From: "bejoy...@yahoo.com" To: user@hive.apache.org; Raj Hadoop ; User S

Re: Hive on Oracle

Hi The procedure is same as setting up mysql metastore. You need to use the jdbc driver/jar corresponding to the oracle version/release you are intending to use. Regards Bejoy KS Sent from remote device, Please excuse typos -Original Message- From: Raj Hadoop Date: Fri, 17 May 2013 1

Hive on Oracle

Hi, I am planning to install Hive and want to set up Meta store on Oracle. What is the procedure? Which driver (JDBC) do I need to use it? Thanks, Raj

Re: collect_set question

Hi The Hive Programming Book explains how to implement a "collect" function that returns a list (instead of set) of objects…perhaps u can tweak this to return the N number of items in List Thanks sanjay From: Robert Li mailto:robert...@kontagent.com>> Reply-To: "user@hive.apache.org

collect_set question

For collect_set is it possible to only collect a few elements and then stop? For example Select user,collect_set(timestamp) from XYZ group by user. For each user, there could be hundreds of timestamps, but I only need 3 or 4 per user. Is there a way to tell collect_set to stop collecting after it

Re: need help with an error - script used to work and now it does not :-(

ok. so it sounds like you are doing A/B testing then. so if it works in your sandbox but doesn't in prod then you can slowing transform your sandbox - one component at time - to look like your prod system until it breaks. The last component you add then is an area of interest. CTAS is short for

Re: need help with an error - script used to work and now it does not :-(

in the meantime why don't you breakup your single query into a series of queries (using CTAS semantics to create intermediate tables ). The idea is narrow the problem down to a minimal size that _isolates the problem_ . what you have there is overly complex to expect someone to troubleshoot for

Re: need help with an error - script used to work and now it does not :-(

I am using Hive 0.9.0+155 that is bundled in Cloudera Manager version 4.1.2 Still getting the errors listed below :-( Any clues will be be cool !!! Thanks sanjay From: Sanjay Subramanian mailto:sanjay.subraman...@wizecommerce.com>> Date: Thursday, May 16, 2013 9:42 PM To: "user@hive.apache.or

Re: [ANNOUNCE] Apache Hive 0.11.0 Released

Thanks to all the contributors who helped create this new release! And special thanks to the release managers Ashutosh Chauhan and Owen O'Malley - for driving this release. On Thu, May 16, 2013 at 2:19 PM, Owen O'Malley wrote: > The Apache Hive team is proud to announce the the release of Apa

Fwd: How to read data in column wise (readColumnsBatch())

I have the below code that can read data row wise private void readSpecificColumns() throws IOException, SerDeException { ColumnarSerDe serDe = new ColumnarSerDe(); serDe.initialize(conf, createProperties()); // long start = System.currentTimeMillis(); java.util.A