Hive crashing after an upgrade - issue with existing larger tables

2011-08-18 Thread Bejoy Ks
Hi Experts         I was working on hive with larger volume data  with hive 0.7 . Recently my hive installation was upgraded to 0.7.1 . After the upgrade I'm having a lot of issues with queries that were already working fine with larger data. The queries that took seconds to return results is

Re: Hive crashing after an upgrade - issue with existing larger tables

2011-08-18 Thread bejoy_ks
A small correction to my previous post. The CDH version is CDH u1 not u0 Sorry for the confusion Regards Bejoy K S -Original Message- From: Bejoy Ks bejoy...@yahoo.com Date: Thu, 18 Aug 2011 05:51:58 To: hive user groupuser@hive.apache.org Reply-To: user@hive.apache.org Subject: Hive

Re: Hive crashing after an upgrade - issue with existing larger tables

2011-08-18 Thread Carl Steinbach
Hi, The original CDH3U1 release of Hive contained a configuration bug which we recently fixed in an update. You can get the update by refreshing your Hive packages. Afterwards please verify that you are using the following Hive package: hive-0.7.1+42.9 You can also fix the problem by modifying

Re: Hive DDL issue

2011-08-18 Thread Carl Steinbach
Hive does not work on Cygwin. On Wed, Aug 17, 2011 at 3:38 PM, Siddharth Tiwari siddharth.tiw...@live.com wrote: encountering following issur pls help, on cygwin windows hive show tables; FAILED: Hive Internal Error: java.lang.IllegalArgumentException(java.net.URISyntaxException: Relative

RE: Hive DDL issue

2011-08-18 Thread Siddharth Tiwari
hey carl, Isint there any way to enable it, if not, what is this error about ? what is the problem ? ** Cheers !!! Siddharth Tiwari Have a refreshing day !!! From: c...@cloudera.com Date: Thu, 18 Aug 2011 11:34:03 -0700 Subject: Re: Hive DDL issue To:

Re: Hive DDL issue

2011-08-18 Thread Carl Steinbach
Adding to what Ed said, we don't run regression tests on Cygwin, so Hive on Cygwin is de facto unmaintained. On Thu, Aug 18, 2011 at 12:37 PM, Edward Capriolo edlinuxg...@gmail.comwrote: It did work with cygwin at one point but since it is rarely used in that environment it is not well

RE: Hive DDL issue

2011-08-18 Thread Siddharth Tiwari
okay Ed and Carl, I get the point, the only thing which bothered me was, would it be able to run on cygwin ? what actually was wrong. ** Cheers !!! Siddharth Tiwari Have a refreshing day !!! From: c...@cloudera.com Date: Thu, 18 Aug 2011 13:13:37 -0700 Subject: Re:

Ignore subdirectories when querying external table

2011-08-18 Thread Dave
Hi, I have a partitioned external table in Hive, and in the partition directories there are other subdirectories that are not related to the table itself. Hive seems to want to scan those directories, as I am getting an error message when trying to do a SELECT on the table: Failed with exception

Re: Setting up stats database

2011-08-18 Thread wd
Maybe you should use 'hive.stats.jdbcdriver=org.apache.mysql.jdbc.EmbeddedDriver' settings? via http://mail-archives.apache.org/mod_mbox/hive-user/201103.mbox/%3c42360b00-72ec-437a-9d95-93f3ad9f1...@fb.com%3E On Fri, Aug 19, 2011 at 5:45 AM, bharath vissapragada

How to skip the malformatted records while loading data

2011-08-18 Thread XieXianshan
Hi,everyone, Is there an option to ignore malformatted records while loading data into hive table? Or an option to ignore bad rows while querying data? For instance: 1. Specify a row format explicitly for a new table. hivecreate table tb (id int, pref string, zip string) row format delimited

How to skip the malformatted records while loading data

2011-08-18 Thread XieXianshan
Hi,everyone, Is there an option to ignore malformatted records while loading data into hive table? Or an option to ignore bad rows while querying data? For instance: 1. Specify a row format explicitly for a new table. hivecreate table tb (id int, pref string, zip string) row format delimited

Re: Setting up stats database[SOLVED]

2011-08-18 Thread bharath vissapragada
Hi, I solved this by placing the jar in ${java_home}/jre/lib and ${java_home}/jre/lib/ext . This is the workaround whenever jdbc drivers wont work. The same thing worked here too. (I hope it works with your postgres too). I am still wondering why hive didn't recognize it in the classpath. Also