Re: Fwd: Row exception in Hive while using join

2015-03-10 Thread krish
table_line_n_passed join table_line_c_passed on (table_line_n_passed.chromosome_number=table_line_c_passed.chromosome_number) PS: if i used LIMIT 1 in above query its running fine . On Mon, Mar 9, 2015 at 9:35 PM, Swagatika Tripathy swagatikat...@gmail.com wrote: Hi Krish, It seems the data

how much free disk space require to run Hive query

2015-03-10 Thread krish
within available free space. do i need to set any property or value in hive configuration . PS: if i used LIMIT 1 in above query its running fine . -- with regards krish!!

Re: Row exception in Hive while using join

2015-03-08 Thread krish
* from table_line_n_passed where chromosome_number is not null) a join table_line_c_passed b on a.chromosome_number=b.chromosome_number; On Thu, Mar 5, 2015 at 1:41 PM, Vikram Dixit vik...@hortonworks.com wrote: Hi Krish, Which version of hive are you using? Can you also provide

Re: Row exception in Hive while using join

2015-03-06 Thread krish
hi Vikram, I am using Hive 0.10.0. On Fri, Mar 6, 2015 at 2:11 AM, Vikram Dixit vik...@hortonworks.com wrote: Hi Krish, Which version of hive are you using? Can you also provide the logs for this run? Regards Vikram. From: krish kri22go...@gmail.com Reply-To: user@hive.apache.org

Fwd: Row exception in Hive while using join

2015-03-05 Thread krish
getting this error, and how can I solve it? -- with regards krish!!

How to convert RDBMS DDL to Hive DDL ?

2015-01-08 Thread Krish Donald
Hi, I am new to hive and I have imported data into HDFS using DB2. Now I want to create hive table. I am not sure How to convert RDBMS DDL to Hive DDL ? Can somebody please guide ? Thanks Krish

Re: Newbie to Hive- Errors / Messages while starting Hive

2015-01-05 Thread Krish Donald
But in Hortonworks sandbox , only hive works... so why not when setting up using apache Hadoop .. On Sun, Jan 4, 2015 at 10:58 PM, Mohan Krishna mohan.25fe...@gmail.com wrote: hive shell is the command to enter in to Hive shell On Mon, Jan 5, 2015 at 12:26 PM, Krish Donald gotomyp

Re: Newbie to Hive- Errors / Messages while starting Hive

2015-01-04 Thread Krish Donald
What is the difference between hive shell and hive prompt ... On Sun, Jan 4, 2015 at 10:47 PM, Mohan Krishna mohan.25fe...@gmail.com wrote: Hi Krish, You shall try hive shell Not simply hive Let me know if you still face the same issue Thanks Mohan On Mon, Jan 5, 2015 at 12:09 PM

Newbie to Hive- Errors / Messages while starting Hive

2015-01-04 Thread Krish Donald
) at org.apache.hadoop.fs.Path.initialize(Path.java:203) ... 11 more Thanks Krish

Re: hive table clustering - question

2014-04-26 Thread krish ws
Hi All, Can someone provide has any idea on my above question? Appreciate the help On Thu, Apr 24, 2014 at 7:15 PM, krish ws krisws.2...@gmail.com wrote: Hi, I have a question related to hive table *bucketing* based on multiple columns(*Clustered by* on a common set

hive table clustering - question

2014-04-24 Thread krish ws
)? Will the hashing differs based on few columns vs using all columns that I specified in the *Clustered by* clause on a table? Regards Krish

Exception when joining HIVE tables

2011-09-21 Thread Krish Khambadkone
Hi, I get this exception when I try to join two hive tables or even when I use a specific WHERE clause. SELECT * from any individual table seems to work fine. Any idea what is missing here. I am on hive version hive-0.7.0-cdh3u0. java.lang.IllegalArgumentException: Can not create a Path

Re: Exception when joining HIVE tables

2011-09-21 Thread Krish Khambadkone
Photos on Flickr Also check out my Blog for answers to commonly asked questions. From: Krish Khambadkone kkhambadk...@apple.com To: user@hive.apache.org Sent: Wednesday, September 21, 2011 1:11 PM Subject: Exception when joining HIVE tables Hi, I get this exception when I try to join two

Re: Exception when joining HIVE tables

2011-09-21 Thread Krish Khambadkone
hdfs://localhost:9000/user/hive/warehouse/supplier -Ayon See My Photos on Flickr Also check out my Blog for answers to commonly asked questions. From: Krish Khambadkone kkhambadk...@apple.com To: user@hive.apache.org Sent: Wednesday, September 21, 2011 2:45 PM Subject: Re: Exception

Required table missing : `CDS` in Catalog

2011-09-16 Thread Krish Khambadkone
I have checked out the latest HIVE Trunk and built it. I am now trying to configure a mysql metastore. I ran the script hive-schema-0.7.0.mysql.sql which was the latest one in the list after creating the metastore database. So why is it complaining about this CDS table? 2011-09-16