RE: PLEASE HELP :: HOW TO DO INNER JOIN IN HIVE

Hello yogesh, The only thing hive doesn't support in join is non equi join but in Ur case bellow hive ll definitely support. If u still getting error msg, plz paste it here. There must be something else. Thanks Ashok From: Mohit Durgapal [durgapalmo...@

RE: Querying a time stamp

Try WHERE dataofbirth=unix_timestamp("2011-10-08 00:00:00"); From: Bhuvana Bellala [mailto:bhuvana.bell...@cormac-corp.com] Sent: Monday, July 07, 2014 9:01 PM To: user@hive.apache.org Subject: Querying a time stamp Hi, I have a column called dateofbirth in my hive table and the date of birth is

RE: READING FILE FROM MONGO DB

MongoDB tores in Json Format. Use Json serde in hive while loading. -Ashok From: Swagatika Tripathy [mailto:swagatikat...@gmail.com] Sent: Thursday, March 27, 2014 12:59 AM To: user@hive.apache.org Subject: READING FILE FROM MONGO DB Hi, We have some files stored in MongoDB , mostly in key value

RE: Date format in Hive

Hello Dhari, Write a hive udf, 1.which ll take date as argument. 2.extract yr, mon,date from string, create a new string combining them 3. convert it to numeric and multiply 100.. 4. return this value from udf. Thanks, Ashok From: yogesh dhari [yogeshh...@

RE: FAILED: Hive Internal Error

Where is namenode ? JT - job tracker web interface. If you bont have much data in hadoop and you can afford to loose the data already in hadoop then try > bin/hadoop dfs namenode -format (Apache hadoop) then start your hadoop deamons again. Thanks, Ashok _

RE: FAILED: Hive Internal Error

Can you do a JPS and check all the deamons running fine? If yes check your JT web UI is up or not. Thanks, Ashok From: sagar nikam [sagarnikam...@gmail.com] Sent: Saturday, October 27, 2012 3:14 PM To: user@hive.apache.org; d...@hive.apache.org Subject: Re:

got exception trying to get groups for user

Hello Hive, please find below error from JT log.All of my queries are stuck in 100% 33% or 0% 0%.Any help ll be appreciated. got exception trying to get groups for user XX org.apache.hadoop.util.Shell$ExitCodeException: id: XX: No such user at org.apache.hadoop.util.Shell.runCommand(She

RE: how to load TAB_SEPRATED file in hive table

'\t' From: yogesh dhari [yogeshdh...@live.com] Sent: Thursday, September 27, 2012 10:42 AM To: hive request Subject: how to load TAB_SEPRATED file in hive table Hi all, I have a file in which records are Tab-Seprated, Please suggest me how to upload such f

RE: Hive configuration property

Hello Abhi, Hope below information ll help you. mapred.reduce.tasks * Default Value: -1 * Added In: 0.1 The default number of reduce tasks per job. Typically set to a prime close to the number of available hosts. Ignored when mapred.job.tracker is "local". Hadoop set this to 1 by default

RE: hive server security/authentication

Hi Chalcy, You can go for OAUTH for security purpose if you want to provide specific authorization flows for web applications with hive. Even Google relay on this. But coming to pentaho and all never tried with them. You can give a try. Regards Ashok S. From: Chalcy Raja [mailto:chalcy.r...@ca

RE: Hive configuration property

Yes Abshiek, By setting below prop. You ll get better result. The no should depends on ur data size. Regards Ashok S. From: Bejoy KS [mailto:bejoy...@yahoo.com] Sent: 26 September 2012 21:04 To: user@hive.apache.org Subject: Re: Hive configuration property Hi Abshiek Based on my experience you

RE: warning message while connecting Hive shell

Please set the class path wrt log4J property file Thanks Ashok S. From: Ajit Kumar Shreevastava [ajit.shreevast...@hcl.com] Sent: Monday, September 17, 2012 4:11 PM To: user@hive.apache.org Subject: warning message while connecting Hive shell Hello , When

RE: Error in inserting data into HBase table from Hive

Please check into your conf folder of hive. If you are working on cloudera vm(v-4), below things you have to add in hive-site.xml. hive.aux.jars.path path/to/hive-hbase-handler-0.9.0-cdh4.jar,path/to/hive/lib/hbase-0.92.jar,payh/to/hive/lib/zookeeper-VERSION.jar Regards Ashok S.

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

Yes bejoy i did it today and it's working. But i was thinking by setting some property we can achieve it. Is there anything like that? Thanks Ashok From: Bejoy KS [mailto:bejoy...@yahoo.com] Sent: 13 September 2012 02:40 To: user@hive.apache.org Subject: Re: Performance: hive+hbase integration q

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

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