Re: How to load csv data into HIVE

2012-09-07 Thread Sandeep Reddy P
aster > for such large files. > > Regards, > Mohammad Tariq > > > > On Fri, Sep 7, 2012 at 8:27 PM, Connell, Chuck > wrote: > >> I cannot promise which is faster. A lot depends on how clever your >> scripts are. >> >> ** ** >&g

Re: How to load csv data into HIVE

2012-09-07 Thread Sandeep Reddy P
R&D Data Team > > Burlington, MA > > 781-565-4611 > > ** ** > > *From:* Sandeep Reddy P [mailto:sandeepreddy.3...@gmail.com] > *Subject:* How to load csv data into HIVE > > ** ** > > Hi, > Here is the sample data > "174969274",

Re: Hive+Hbase Integration Error.

2012-08-20 Thread Sandeep Reddy P
a.HiveException: Hive Runtime Error while processing row {"foo":98,"bar":"abc"} at org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:546) at org.apache.hadoop.hive.ql.exec.ExecMapper.map(ExecMapper.java:143) ... 8 more Caused

Hive+Hbase Integration Error.

2012-08-20 Thread Sandeep Reddy P
Hi, I want to integrate Hive and Hbase Tables. I created a table in hive using Stored By. When i try to load data into that table using INSERT OVERWRITE TABLE hbase_table_1 SELECT * FROM pokes; I got the following exceptions, FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.ex

Re: Hive append support

2012-08-09 Thread Sandeep Reddy P
HI, Can we consider using HBASE for the same? On Thu, Aug 9, 2012 at 1:19 PM, Sandeep Reddy P wrote: > Thank you all for the info. > > > On Thu, Aug 9, 2012 at 12:30 PM, Bob Gause wrote: > >> Hive has no update & delete statements. >> >> You can drop a tab

Re: Hive append support

2012-08-09 Thread Sandeep Reddy P
ons out into > intermediate temp tables. We have a lot more tables in our Hive process > than we had in our MySQL/Postgres process. > > Hope this helps…. > Bob > > Robert Gause > Senior Systems Engineer > ZyQuest, Inc. > bob.ga...@zyquest.com > > On Aug 9, 2012, a

Re: Hive append support

2012-08-09 Thread Sandeep Reddy P
ly. > > Regards, > Bejoy KS > > ------ > *From:* Sandeep Reddy P > *To:* u...@hadoop.apache.org > *Cc:* user@hive.apache.org; cdh-u...@cloudera.org > *Sent:* Thursday, August 9, 2012 7:56 PM > *Subject:* Hive append support > > Hi, > Is there any version of

Re: schema of hive database

2012-08-02 Thread Sandeep Reddy P
Nice one worked for me. On Thu, Aug 2, 2012 at 4:03 PM, Anson Abraham wrote: > pretty much what you did. I didn't realize that it was in the docs > already: > > > https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-DescribeTable%2FColumn > > Not sure, but I thin