Re: Hive and CDH4 GA

See https://issues.apache.org/jira/browse/HADOOP-8350?focusedCommentId=13414276&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-13414276 Cheers On Fri, Jul 13, 2012 at 12:38 PM, kulkarni.swar...@gmail.com < kulkarni.swar...@gmail.com> wrote: > Has anyone being using

Thrift Client

Hi All, After using ThriftHive.Client.execute(query), how to get the value of each column individually? Instead of using fetchAll() or fetchN() or fetchOne(), which alway concatenate all the values of all columns in one row into a String (separated by a tab character). More specific: Suppos

Anything wrong with this query?

Whenever I try to run this below query, I always get error as OR is not supported in JOIN? Is there any other way of doing this query? SELECT * FROM TestingTable1 tt1 LEFT JOIN TestingTable2 tt2 ON tt1.buyer_id = tt2.user_id AND (tt1.item_id = tt2.product_id OR unix_ti

SELECT from Union of Structs

I've created a hive table using the AVRO SerDe's sitting on top of a schema containing a union of records, similar to: { "name": "Foo", "type": "record", "fields": [ { "name": "foo", "type": "int" }, { "name": "details", "type": [ { "name": "Bar", "type": "record",

Array of Structs

Hi all, How to create an array of structs in hive? And How to populate that table with data? Please help. Thanks and regards, Snehalata Deorukhkar Nortel No:0229-5814 Confidential: This electronic message and all contents contain information from Syntel, Inc. which may be privil