unable to view the data in the hive tables

2012-07-15 Thread shaik ahamed
Hi All, Please help me in gng forward with below error ,as im unable to see the table data . hive> show tables; Shutting down due to severe error. FAILED: Error in metadata: javax.jdo.JDODataStoreException: Failed to start database 'metastore_db', see the next exception for details. Ne

How would you write a query for a use-case I have

2012-07-15 Thread Guy Doulberg
Hi guys, I have a table with three fields, (uid,event_guid,timestamp) I need to find out for each event_guid the index of it in the context of the user. I want to extract a table with the fields (event_guid, index). * each event has a unique guid. Example u1, ue1, 111 .. u1,ue2,

RE: DATA UPLOADTION

2012-07-15 Thread yogesh.kumar13
Hello Debarshi, Please suggest me what tool should I use for these operation over hadoop dfs. Regards Yogesh Kumar From: Debarshi Basak [debarshi.ba...@tcs.com] Sent: Monday, July 16, 2012 11:25 AM To: user@hive.apache.org Cc: user@hive.apache.org; u...@hbase.apa

Re: DATA UPLOADTION

2012-07-15 Thread Debarshi Basak
Hive is not the right to go about it, if you are planning to do search kind of operationsDebarshi BasakTata Consultancy ServicesMailto: debarshi.ba...@tcs.comWebsite: http://www.tcs.comExperience certainty. IT Services Business Solutions Outsourcing_

DATA UPLOADTION

2012-07-15 Thread yogesh.kumar13
Hi all, I have data of Flat files, Log files, Images and .xls Files of around many G.B I need to put operation like searching, Querying over that raw data. and generating reports. And its impossible to create tables manually for all to manage them. Is there any other way out or how to manage t