RE: FAILED: Error in metadata

2012-09-11 Thread rohithsharma
Hi Exception trace clearly indicates that hive is pointing to default configurations. Make sure your editing hive-site.xml is loaded by hive server. For verifying whether correct configurations are loaded, you enable DEBUG logs. There you can see the loaded configurations. Verify your configu

RE: FAILED: Error in metadata

2012-09-11 Thread yogesh dhari
thanks all for your guidance :-) its done now Regards Yogesh kumar From: rohithsharm...@huawei.com To: user@hive.apache.org Subject: RE: FAILED: Error in metadata Date: Tue, 11 Sep 2012 14:35:18 +0530 Hi Exception trace clearly indicates that hive is pointing to default configurations.Make su

How to update and delete a row in hive

2012-09-11 Thread Ramasubramanian
Hi, What is the command to update/delete a row from hive? If not directly possible what is the work around for that? Regards, Rams

RE: How to update and delete a row in hive

2012-09-11 Thread Connell, Chuck
Hive does not support row-level (or field-level) updates. It is designed as a WORM (write once read many) data warehouse. You can of course code your own row updates by reading an entire Hive file, modifying a row, then writing the file back to Hive. Chuck Connell Nuance R&D Data Team Burling

Performance: hive+hbase integration query against the row_key

2012-09-11 Thread Shengjie Min
Hi, I am trying to get hive working on top of my hbase table following the guide below: https://cwiki.apache.org/Hive/hbaseintegration.html CREATE EXTERNAL TABLE hive_hbase_test (key string, a string, b string, c string) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPE

Re: Performance: hive+hbase integration query against the row_key

2012-09-11 Thread bharath vissapragada
Hey, Hive does all kinds of parsing , metadata lookups, query tree building and stuff before executing the query. Not sure if this all was included in those 36 seconds ! Also what hive does is, it builds a scan object with ranges based on predicates (and mappers too ) on key column and not a dire

Re: How to update and delete a row in hive

2012-09-11 Thread Bejoy KS
Hi Rams Adding on to Chuck's comments. In hive you can get a work around for updates and deletes only by overwriting a table or atleast a partition if table is partitioned. If updates cannot be avoided for your use case, I suggest you to partition and sub partition your table accordingly so tha

Re: Performance: hive+hbase integration query against the row_key

2012-09-11 Thread Alan Gates
On Sep 11, 2012, at 7:00 AM, bharath vissapragada wrote: > Hey, > > Hive does all kinds of parsing , metadata lookups, query tree building and > stuff before executing the query. Not sure if this all was included in those > 36 seconds ! > > Also what hive does is, it builds a scan object wi

RE: Performance: hive+hbase integration query against the row_key

2012-09-11 Thread ashok.samal
after loading the data into hive tables, the files gets automatically deleted from HDFS...how to stop that? Thanks Ashok -Original Message- From: Alan Gates [mailto:ga...@hortonworks.com] Sent: 12 September 2012 06:51 To: user@hive.apache.org Subject: Re: Performance: hive+hbase integrat

RE: Hive or Hbase connectivity to jaspersoft reporting

2012-09-11 Thread Bhaskar, Snehalata
You may find this link helpful http://www.javacodegeeks.com/2012/02/big-data-analytics-with-hive-and.ht ml . The steps to generate reports from hive tables using Jaspersoft are nicely explained in that article. Thanks and regards, Snehalata Deorukhkar Nortel No : 0229 -5814 From: iwa