Re: Handling blob in hive

You can store Blob data type as string in hive. Thanks, Saurabh Sent from my iPhone, please avoid typos. > On 08-Aug-2014, at 9:10 am, Chhaya Vishwakarma > wrote: > > Hi, > > I want to store and retrieve blob in hive.Is it possible to store blob in > hive? > If it is not supported what al

Getting access to hadoop output from Hive JDBC session

Hello, I am switching from Hive 0.9 to Hive 0.12 and decided to start using Hive metadata server mode. As it turns out, Hive1 JDBC driver connected as "jdbc:hive://" only works via direct access to the metastore database. The Hive2 driver connected as "jdbc:hive2://" does work with the remote H

Altering the Metastore on EC2

We are creating an Hive schema for reading massive JSON files. Our JSON schema is rather large, and we have found that the default metastore schema for Hive cannot work for us as-is. To be specific, one field in our schema has about 17KB of nested structs within it. Unfortunately, it appears th

Re: error on show databases

Are u using mysql as the metastore ? Thanks Warm Regards sanjay From: Rahul Channe mailto:drah...@googlemail.com>> Reply-To: "user@hive.apache.org" mailto:user@hive.apache.org>> Date: Thursday, August 7, 2014 at 7:35 AM To: "user@hive.apache.org

New to TEZ

Hi, This might be very silly error. Below was my log.. I couldnt find where the error is. Can you please point out what caused my error... Regards, Karthik . Map 1: -/- Reducer 2: 0/20 Map 1: 0/138Reducer 2: 0/20 Map 1: 0/138Reducer 2: 0/20 Map 1: 0/138Reducer 2: 0/20 Map 1: 0

Re: How to query UNION types in Hive with Avro

Thanks Vikas, I did see the below URL before posting but it is not clear to me how I run a select query. For example, if the union ‘x’ is: uniontype,struct> Then how do I run the query: select x.a from tbl; Thanks Sachin From: hadoop hive mailto:hadooph...@gmail.com>> Reply-

Neverending SQL query execution: jdbc + hive

I'm executing some queries using HiveServer2 and jdbc. Once in a while my application gets stuck with an output like this (on random query, nondeterministic): 07:24:54.910 [pool-4-thread-1] DEBUG o.a.thrift.transport.TSaslTransport - > CLIENT: reading data length: 53 > 07:24:54.910 [pool-4-thread-

Neverending SQL query execution: jdbc + hive

Hi, I'm executing some queries using HiveServer2 and jdbc. Once in a while my application gets stuck with an output like this (on random query, nondeterministic): 07:24:54.910 [pool-4-thread-1] DEBUG o.a.thrift.transport.TSaslTransport - > CLIENT: reading data length: 53 > 07:24:54.910 [pool-4-th

Re: How to query UNION types in Hive with Avro

Hi Sachin, Here is the doc from hwk, this might help you. http://docs.hortonworks.com/HDPDocuments/HDP1/HDP-1.2.2/ds_Hive/language_manual/datatypes.html#LanguageManualTypes-UnionTypes Thanks Vikas Srivastava On Aug 12, 2014 12:31 AM, "Sachin Goyal" wrote: > Hi, > > I am using Hive and Avro wi

How to query UNION types in Hive with Avro

Hi, I am using Hive and Avro with union types as follows: hive> desc tbl1; productid uniontype,struct> from deserializer hive> select productid from tbl1; {1:{"productid":"34","itemid":null}} hive> select productid.productid from tbl1 FAILED: SemanticException [Error 10042]: L

Neverending SQL query execution: jdbc + hive

I'm executing some queries using HiveServer2 and jdbc. Once in a while my application gets stuck with an output like this (on random query, nondeterministic): 07:24:54.910 [pool-4-thread-1] DEBUG o.a.thrift.transport.TSaslTransport - > CLIENT: reading data length: 53 > 07:24:54.910 [pool-4-thread-

Re: ORC String error

Hi! The workaround: “set hive.optimize.index.filter=false" doesn't work. Still ArrayIndexOutOfBounds by select max(length(url)) query. Kindly regards Wojciech Indyk 2014-08-11 8:49 GMT+02:00 Prasanth Jayachandran : > Hi > > My suspicion for the error is because of this issue > https://issues.apac