how to make async call to hive

2013-09-29 Thread kentkong_work
hi all, just wonder if there is offical solution for async call to hive? hive query runs so long time, my application can't block until it returns. Kent

how to know a hive query failed

2013-07-16 Thread kentkong_work
hi, I use a shell script to run hive query in background, like this hive -e "select uname, age from usertable" >> result.csv & sometimes, the hive query failed, but I can't find. only thing I can do is waiting for long time, 5 or 6 hours, if I still can't see the result.csv, I kno

export csv, use ',' as split

2013-07-09 Thread kentkong_work
hi here, I create a table like this and put a lot data into it. then I export query result into csv file like this: hive -e myquery >> result.csv but the csv uses tab as split. how to make hive use ','? thanks! CREATE TABLE if not exists upload_users( username string, mobile

Re: Re: How to connect to HiveServer 2? (Only through JDBC?)

2013-06-26 Thread kentkong_work
hehe, I cann't find any document about the thrift api like you does somebody know how to use thrift? 2013-06-26 kentkong_work 发件人:Christian Schneider 发送时间:2013-06-26 22:27 主题:Re: How to connect to HiveServer 2? (Only through JDBC?) 收件人:"user" 抄送: Funny :). But that'

Re: How to connect to HiveServer 2? (Only through JDBC?)

2013-06-26 Thread kentkong_work
ry finished, a little complexity, use Jsch to execute "hive -e select ... >> result.csv &" then start a thread, use Jsch to execute "mv result.csv result.c" every 3 mins, you can know if the mv successful by call Jsch API if success, then the query ends 2013-06-26

does any know how to use TCLIService.AsyncClient

2013-06-21 Thread kentkong_work
hi dear all, I want to use TCLIService.AsyncClient to perform async query to hive, and want to query the query execute status to check if it finished. there is little information about the AsyncClient, does anyone have example codes or some documents? my hive version is 0.11 Kent