Re: '\N' is displayed in case of null column values in exporting hive query results to CSV file

2012-05-01 Thread Ashwanth Kumar
> > ** ** > _ > The information contained in this message is proprietary and/or > confidential. If you are not the intended recipient, please: (i) delete the > message and all copies; (ii) do not disclose, distribute or use the message > in any manner; and (iii) notify the sender immediately. In addition, please > be aware that any message addressed to our domain is subject to archiving > and review by persons other than the intended recipient. Thank you. > -- Ashwanth Kumar / ashwanthkumar.in

Re: '\N' is displayed in case of null column values in exporting hive query results to CSV file

2012-05-01 Thread Ashwanth Kumar
are not the intended recipient, please: (i) delete the > message and all copies; (ii) do not disclose, distribute or use the message > in any manner; and (iii) notify the sender immediately. In addition, please > be aware that any message addressed to our domain is subject to archiving > and review by persons other than the intended recipient. Thank you. > -- Ashwanth Kumar / ashwanthkumar.in

Re: add column to hive table

2012-04-30 Thread Ashwanth Kumar
; Thanks, > > Chalcy > > ** ** > > ** ** > -- Ashwanth Kumar / ashwanthkumar.in

Re: Any column search in HIVE

2012-04-30 Thread Ashwanth Kumar
dential. If you are not the intended recipient, please: (i) delete the > message and all copies; (ii) do not disclose, distribute or use the message > in any manner; and (iii) notify the sender immediately. In addition, please > be aware that any message addressed to our domain is subject to archiving > and review by persons other than the intended recipient. Thank you. > -- Ashwanth Kumar / ashwanthkumar.in

Re: Re: cannot start the thrift server

2012-04-10 Thread Ashwanth Kumar
server > Starting Hive Thrift Server > > After starting Hive Thrift Server nothing get printed on console. This > means your server get started. > > Now you just run your JDBC program and let us know whether it runs or not. > > > -- > Regards, > > Bhavesh Shah > > > > > > > > On Tue, Apr 10, 2012 at 6:03 PM, ylyy-1985 wrote: > > hi all, > > I do feel frustrated when starting the thrift server. I tried different > version of hadoop(1.0.1 and 0.20.2), but when I tried 'hive --service > hiveserver', the server hung there and printed the following info: > > [root@localhost hive]# hive --service hiveserver > Starting Hive Thrift Server > 12/04/10 20:22:50 INFO service.HiveServer: Starting hive server on port > 1 > > and I wait long but nothing happened. pls help, I just want to start the > server and use jdbc to connect to hive. > > thanks in advanced. > > 2012-04-10 > -- > > Andes > > > > > -- Ashwanth Kumar / ashwanthkumar.in <><>

Re: Hive table creation error

2012-04-05 Thread Ashwanth Kumar
.runWorker(ThreadPoolExecutor.java:1110)\njava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)\njava.lang.Thread.run(Thread.java:636)\n', > clazz='java.lang.reflect.UndeclaredThrowableExceptio)] > > Thank You, > Manish > -- Ashwanth Kumar / ashwanthkumar.in

Re: Question - Nested JSON using Hive

2012-04-02 Thread Ashwanth Kumar
ot;:"105540216147364","name":"Phoenix, > Arizona"},"position":{"id":"144703015548786","name":"Pharmacy > Tech"},"start_date":"2001-02","end_date":"2005-10"}],"sports":

Re: Question - Nested JSON using Hive

2012-04-01 Thread Ashwanth Kumar
> > MAP, > > MAP, > > start_date STRING, > > end­_date STRING > > >, > > education ARRAY< > > MAP, > > STRING > > >, > > gender STRING, > > interested_in ARRAY< > > STRING > > >, > > relationship_status STRING, > > religion STRING, > > political STRING, > > email STRING, > > website STRING, > > timezone INT, > > locale STRING, > > language ARRAY< > > STRING, > > STRING > > >, > > verified STRING, > > updated_time STRING > > ) > > ROW FORMAT SERDE 'org.openx.data.jsonserde.JsonSerDe' STORED AS TEXTFILE;* > *** > > ** ** > > LOAD DATA LOCAL INPATH '/export/home/me/json_data.txt' OVERWRITE INTO > TABLE USERS; > > ** ** > > ** ** > > When I run this code I get the error: > > FAILED: Parse Error: line 10:0 mismatched input 'location' expecting > Identifier near ',' in column specification > > ** ** > > Can you please tell me what I’m doing wrong and how to fix it? > > ** ** > > I appreciate it!!! > > ** ** > > ** ** > > Regards, > > ** ** > > Anurag G. > > American Express made the following annotations on Sun Apr 01 2012 > 18:37:49 > ** > > "This message and any attachments are solely for the intended recipient > and may contain confidential or privileged information. If you are not the > intended recipient, any disclosure, copying, use, or distribution of the > information included in this message and any attachments is prohibited. If > you have received this communication in error, please notify us by reply > e-mail and immediately and permanently delete this message and any > attachments. Thank you." > American Express a ajouté le commentaire suivant le Sun Apr 01 2012 > 18:37:49 > Ce courrier et toute pièce jointe qu'il contient sont réservés au seul > destinataire indiqué et peuvent renfermer des renseignements confidentiels > et privilégiés. Si vous n'êtes pas le destinataire prévu, toute > divulgation, duplication, utilisation ou distribution du courrier ou de > toute pièce jointe est interdite. Si vous avez reçu cette communication par > erreur, veuillez nous en aviser par courrier et détruire immédiatement le > courrier et les pièces jointes. Merci. > > ** > > > --- > > -- Ashwanth Kumar / ashwanthkumar.in