Using newest hive release (0.5.0) - Problem with count(1)

In the past I have used hive 0.3.0 successfully and now with a new project coming up I decided to give hive 0.5.0 a run and everything is working as expected, except for when I try to get a simple count of the table. The simple table is defined as: create table log_table (col1 string, col2

Re: UDAF on AWS Hive

Thanks Zheng, and thanks for your great support to this list. I took your idea and wrote the following code that worked for me...I'm no Java whiz...so it's probably fairly inefficient. I do get to talk to the Amazon folks from time to time, so I'll definitely mention my interest in upgrading the

Re: Using newest hive release (0.5.0) - Problem with count(1)

I am using 1.6, however it is the IBM jvm (not my choice). If the feature is known to work on the Sun JVM then I will deal with the problem another way. Thanks. Aaron On Tue, Apr 6, 2010 at 3:12 PM, Zheng Shao zsh...@gmail.com wrote: Are you using Java 1.5? Hive now requires Java 1.6 On

Issue in installing Hive

I'm trying to run Hive 0.5 release with Hadoop 0.20.2 on a standalone machine. HDFS + Hadoop is working, but I'm not able to get Hive running. When I do SHOW TABLES, I get the following error: http://pastebin.com/XvNR0U86 What am I doing wrong here? Amandeep Amandeep Khurana Computer Science

Re: Using newest hive release (0.5.0) - Problem with count(1)

Yes we use sun jdk 1.6 and it works. On Tue, Apr 6, 2010 at 12:32 PM, Aaron McCurry amccu...@gmail.com wrote: I am using 1.6, however it is the IBM jvm (not my choice).  If the feature is known to work on the Sun JVM then I will deal with the problem another way.  Thanks. Aaron On Tue, Apr

Re: Issue in installing Hive

Hi Amandeep, This problem arises if you grab a copy of the Hadoop tar ball and attempt to build it. The tar ball comes packaged with a copy of core-3.1.1.jar in the lib/ subdirectory, and building the package results in another copy of core-3.1.1.jar located in build/ivy/lib/Hadoop/common/core.

Truncation error when creating table with column containing struct with many fields

Hello, I got the following error when creating a table with a column that has an ARRAY of STRUCTS with many fields. It appears that there is a 128 character limit on the column definition. FAILED: Error in metadata: javax.jdo.JDODataStoreException: Add request failed : INSERT INTO COLUMNS

Re: Truncation error when creating table with column containing struct with many fields

That change should be fine. Zheng On Tue, Apr 6, 2010 at 5:16 PM, Dilip Joseph dilip.antony.jos...@gmail.com wrote: Hello, I got the following error when creating a table with a column that has an ARRAY of STRUCTS with many fields.  It appears that there is a 128 character limit on the