SELECT ... LIMIT N,M and Having statement

Does hive support SELECT ... LIMIT N,M statement and Having in hive0.7? Thanks, LiuLei

how to receive row numbers about inserting data into Hive Tables from queries sql

I use JDBC to connection hive server. I run insert clause, example: insert overwrite table test1 select * from test , how can I receive the row numbers of the sql? I use hive0.6 version. Thanks, LiuLei

don't use DBCP to connection mysql

I know hive mestore use DBCP to connection mysql, I want to use short connection to connection mysql, how can I close DBCP configuration? Thanks, LiuLei**

create table error

When I execute "create table tag16(auction int, tagid int, cost double, title string, description string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','" , the hive throw "AILED: Error in metadata: javax.jdo.JDOException: Couldnt obtain a new sequence (unique id) : Binary logging not possible. Mess

After colse the JDBC connection, the hive don't delete hive exec scratch dir

I use hive 0.6 version, I use JDBC to execute one search sql, for example below code: public static void query() { Connection hiveConnection = null; Statement statement = null; try { Class.forName("org.apache.hadoop.hive.jdbc.HiveDriver"); hiveConne

what char represents NULL value in hive?

I generate HDFS file , then I load the file to one hive table. There are some colums are don't have value, I need to set these colums to NULL. I want to know what char represents NULL value in hive. Thanks, LiuLei

which thrift version hive0.6 use?

Now there is thrift 0.5 version, dose hive0.6 use thrift 0.5 version? Thanks, LiuLei

How to receive File input paths about one select statement

There is select statement, as below: SELECT itemId FROM (SELECT user_id AS itemId FROM r_dm_pv_vstcat1_dm WHERE cat_id1 IN ('14', '1101', '1201', '50008090', '50012164', '11', '1512') AND (pt <= recentdate('dd',1) AND pt >= recentdate('dd',5)) GROUP BY user_id ) sqTab limit 30; recentdate is

When I create one table, hive throw one Exception

When I create one table, hive throw below Exception: 2010-11-03 09:42:02,939 ERROR exec.DDLTask (SessionState.java:printError(277)) - FAILED: Error in metadata: java.lang.RuntimeExcepti on: commitTransaction was called but openTransactionCalls = 0. This probably indicates that there are unbalanced

Re: I use JDBC to run "dfs -lsr hdfs://hdpnn:9000/group/hive/" command, but ResultSet don't return value

he way to judge whether the directory is in HDFS? Thanks. 2010/10/25 Edward Capriolo > On Mon, Oct 25, 2010 at 9:04 AM, lei liu wrote: > > I use JDBC to run "dfs -lsr hdfs://hdpnn:9000/group/hive/" command, but > > ResultSet don't return value, the cod

I use JDBC to run "dfs -lsr hdfs://hdpnn:9000/group/hive/" command, but ResultSet don't return value

I use JDBC to run "dfs -lsr hdfs://hdpnn:9000/group/hive/" command, but ResultSet don't return value, the code like below: Class.forName("org.apache.hadoop.hive.jdbc.HiveDriver"); hiveConnection = DriverManager.getConnection("jdbc:hive:// 10.232.11.53:1/default" , "root"

hive server process is killed

I use the "nohup ./hive --service hiveserver 1&" command to start hive server. But after some time, I find the hive server process is killed. I error message like below : 2010-10-25 19:00:05,030 ERROR exec.DDLTask (SessionState.java:printError(277)) - FAILED: Error in metadata: java.lang.Ille

Search the newest partition of one table in view

There is one table, I use one timer to create one new partition for the table every day, now I want to create one view, use the view to search the newest partition of the table,how can I receive the newest partition of the table in view? Thanks, LiuLei

I define one UDF function, the UDf retunr List ,but When I use ResultSet to receive result hive throw exception

I define one UDF function, like as below : public class TestUDF extends GenericUDF{ private ObjectInspector[] argumentOIs; @Override public Object evaluate(DeferredObject[] arguments) throws HiveException { ArrayList result = new ArrayList(); DoubleWritable[] bin = new Dou

Re: when is hive0.6 released

ok, thank you very much. 2010/10/15 Carl Steinbach > Hi, > > HIVE-1681 does not require any changes to the database schema. It is > strictly > a code change. > > Carl > > > On Thu, Oct 14, 2010 at 11:19 PM, lei liu wrote: > >> Hi Carl Steinbach, >>

Re: when is hive0.6 released

p;sorter/order=DESC&sorter/field=priority&resolution=-1&pid=12310843&fixfor=12314524 > > Thanks. > > Carl > > On Thu, Oct 14, 2010 at 7:53 PM, lei liu wrote: > >> Hi Carl Steinbach , >> >> Thank you for your reply quickly. >> >> I look the

Re: when is hive0.6 released

Thanks, LiuLei 2010/10/15 Carl Steinbach > Hi, > > We're working on building the first release candidate for 0.6. I expect > that > the official release will happen soon, but I can't promise that it will > occur it in the next week. > > Thanks. > > Carl

when is hive0.6 released

This month our system will be released, so I want to use newest hive0.6 version, I want to know hive0.6 whether can be released in next week. Thanks, LiuLei

When I close the connection, hive don't clean hive.exec.scratchdir directory

I use JDBC to connection hive server, I find when I close connection, hive don't clean hive.exec.scratchdir directory, so after hive run long time, the hive.exec.scratchdir directory include a lot of files. Now we use timer to clean the directory, but I think hive should add one plugin for closin

I define outputformat class, but the class don't take effect

I define inputformat and outputformat for one tables, example below: create table test3 ( id int, name string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS inputformat 'my.format.MyInputFormat' outputformat 'my.format.MyOutputFormat'. I find the my.format.MyInputFormat class take ef