Question regarding Hive data type specifics

2010-08-02 Thread Kirk True
Hi all, I have two questions regarding data types in Hive: 1. Does Hive support NON-NULL constraints during table creation or 'alter table' statements? 2. What is the precision and scale of floating point types? Thanks, Kirk

Re: [hive-users] questions regarding hive partitions

2009-11-04 Thread Andrey Pankov
om: Andrey Pankov > Date: Wed, 4 Nov 2009 07:51:03 -0800 > To: > Subject: [hive-users] questions regarding hive partitions > > Hi guys, > > I recently started to investigate Hive, so far I have several questions. > > 1). I have a table A partitioned by column x INT. The

Re: [hive-users] questions regarding hive partitions

2009-11-04 Thread Prasad Chakka
re is very useful and has been requested for some time. Not sure if any one is working on it but contributions are welcome :) Prasad From: Andrey Pankov Date: Wed, 4 Nov 2009 07:51:03 -0800 To: Subject: [hive-users] questions regarding hive partitions Hi guys,

questions regarding hive partitions

2009-11-04 Thread Andrey Pankov
Hi guys, Recently I started to investigate Hive, so far I have several questions. 1). I have a table A partitioned by column x INT. The table has several partitions say x=1, x=2, x=10. Running query "select max(x) from A" hive runs map-reduce job trying to find column x inside data files. Is it p

Re: Problem regarding Hive Command Line Interface

2009-11-04 Thread Prasad Chakka
Feel free to add it :) From: Edward Capriolo Reply-To: Date: Wed, 4 Nov 2009 07:40:41 -0800 To: Subject: Re: Problem regarding Hive Command Line Interface You should check out... http://wiki.apache.org/hadoop/HiveDerbyServerMode @hive-dev: I think we should

Re: Problem regarding Hive Command Line Interface

2009-11-04 Thread Edward Capriolo
You should check out... http://wiki.apache.org/hadoop/HiveDerbyServerMode @hive-dev: I think we should add this more clearly in the readme file. It is great that hive works out of the box but. I think 99% of users, in the long run, are going to want to run hive with a remote meta store db. I

Re: Problem regarding Hive Command Line Interface

2009-11-03 Thread Zheng Shao
Yes, but you would need to set up hive mysql metastore. It's on Hive wiki I believe. Zheng On Tue, Nov 3, 2009 at 11:10 PM, Mohan Agarwal wrote: > Hi, > Can I run multiple Hive CLI from different systems ponting over common > hadoop ? > > Thanking You > Mohan Agarwal > -- Yours, Zheng

Problem regarding Hive Command Line Interface

2009-11-03 Thread Mohan Agarwal
Hi, Can I run multiple Hive CLI from different systems ponting over common hadoop ? Thanking You Mohan Agarwal

Re: Problem regarding hive-jdbc driver

2009-10-26 Thread Bill Graham
Not all methods in the JDBC spec are implemented, as your noticing. Statement.setMaxRows(int) is implemented though, so maybe that would work for your needs. Or you could just specify a limit in your sql. Bill On Mon, Oct 26, 2009 at 6:21 AM, Mohan Agarwal wrote: > Hi everyone, >

Problem regarding hive-jdbc driver

2009-10-26 Thread Mohan Agarwal
Hi everyone, I am writing a java program to create a Query Editor to a execute query through hive. I am using hive-jdbc driver for database connection and query execution, but I am facing a problem regarding java.sql.Statement class. When I am using setFetchSize() of Statement cla

Re: Regarding Hive

2009-07-07 Thread Amr Awadallah
ep --I hive' to see all the hive processes on your unix system. Prasad *From: *Haritha Javvadi *Date: *Tue, 7 Jul 2009 17:34:28 -0700 *To: *Prasad Chakka *Subject: *Re: Regarding Hive Hey, OK.got it.Can

Re: Regarding Hive

2009-07-07 Thread Prasad Chakka
system. Prasad From: Haritha Javvadi Date: Tue, 7 Jul 2009 17:34:28 -0700 To: Prasad Chakka Subject: Re: Regarding Hive Hey, OK.got it.Can you suggest me whats the method involved in killing the process. What should be done to kill the process. I think, the mistake I have done

Re: Regarding Hive

2009-07-07 Thread Prasad Chakka
details on how to set up metastore for multiple hive clients ( http://wiki.apache.org/hadoop/Hive/AdminManual/MetastoreAdmin ) Prasad From: Namit Jain Reply-To: Date: Tue, 7 Jul 2009 16:31:40 -0700 To: Haritha Javvadi Cc: Subject: RE: Regarding Hive Haritha

RE: Regarding Hive

2009-07-07 Thread Namit Jain
Haritha, Please post your questions on hive-user@hadoop.apache.org<mailto:hive-user@hadoop.apache.org> Thanks, -namit From: Haritha Javvadi [mailto:haritha.javv...@gmail.com] Sent: Tuesday, July 07, 2009 4:29 PM To: Namit Jain Subject: Regarding Hive Hello, This is haritha