Re: Operators and || do not work

2013-09-19 Thread Thiruvel Thirumoolan
Hi Amareshwari/Ashutosh, Ashutosh is probably right, I doubt if this ever worked. I couldn't find a clientpositive test case which uses or ||. I also modified a unit test case in Hive9 to use instead of AND and that failed with the same error Amareshwari saw. Hive9 does not have HIVE-2439.

Re: [ANNOUNCE] New Hive Committer - Thejas Nair

2013-08-20 Thread Thiruvel Thirumoolan
Congrats Thejas! On Aug 20, 2013, at 8:00 AM, Bill Graham billgra...@gmail.commailto:billgra...@gmail.com wrote: Congrats Thejas! On Tue, Aug 20, 2013 at 7:32 AM, Jarek Jarcec Cecho jar...@apache.orgmailto:jar...@apache.org wrote: Congratulations Thejas! Jarcec On Tue, Aug 20, 2013 at

Re: HBase -- Hive / HCatalog -- PIG

2013-07-10 Thread Thiruvel Thirumoolan
Hi Rajesh, You might be interested in HIVE-4331 for the Pig integration. I think Viraj had tested this entire use case on a secure cluster. -Thiruvel From: Rajesh Balamohan rajesh.balamo...@gmail.commailto:rajesh.balamo...@gmail.com Reply-To: user@hive.apache.orgmailto:user@hive.apache.org

Re: Rename external table, including HDFS directory

2013-03-07 Thread Thiruvel Thirumoolan
https://cwiki.apache.org/Hive/languagemanual-ddl.html#LanguageManualDDL-Ren ameTable The link mentions that it changes the directory also. If not you can change the table name and then use alter table table name set location new location Let us know what you see. On 3/7/13 3:29 PM, Keith Wiley

Re: CREATE DATABASE WITH LOCATION

2012-12-04 Thread Thiruvel Thirumoolan
This feature (HIVE-1537) was added in Hive 0.8. On 12/4/12 7:37 PM, abhishek abhishek.dod...@gmail.com wrote: hi all, I am trying the below query Create database Location '/my/preferred/directory' But getting the below error FAILED: Parse Error : line 2:0 mismatched input 'LOCATION'

Re: Hive Meta Information

2012-04-02 Thread Thiruvel Thirumoolan
1. recent users of table, 2. top users of table, Hive metastore has audit support (HIVE-1948). While what Edward suggests will be accurate, audit log might give you a superset of that, it will also include desc table requests. Thiruvel On 3/31/12 8:39 PM, Edward Capriolo

Re: Executing query and storing output on HDFS

2012-03-29 Thread Thiruvel Thirumoolan
This should help. https://cwiki.apache.org/Hive/languagemanual-dml.html#LanguageManualDML-Wri tingdataintofilesystemfromqueries On 3/29/12 4:48 PM, Paul Ingles p...@oobaloo.co.uk wrote: Hi, I'd like to be able to execute a Hive query and for the output to be stored in a path on HDFS (rather

Re: How to add hours/minutes to a timestamp column in Hive Query

2011-02-24 Thread Thiruvel Thirumoolan
You can use unix_timestamp(), do the math and convert the result to timestamp. something like from_unixtime(unix_timestamp(Arrival) + n). Use the proper units though. Will that not work for you? On Feb 24, 2011, at 7:57 PM, Bejoy Ks wrote: Hi Experts Could some one please help me out

Re: create table error

2011-01-28 Thread Thiruvel Thirumoolan
Can you change your MySQL configuration binlog_format to ROW ? It should be in /etc/my.cnf I guess. Remember to restart mysql server. -Thiruvel On Jan 28, 2011, at 7:27 PM, Ajo Fod wrote: Seems like you are using a MySQL metadata store ... do you have write permissions on the store? ... can

Re: create table error

2011-01-28 Thread Thiruvel Thirumoolan
A web search of that exception should lead you to that recommendation (or use MIXED instead of ROW or disable binary logging at all if you don't want replication). On Jan 28, 2011, at 7:52 PM, Thiruvel Thirumoolan wrote: Can you change your MySQL configuration binlog_format to ROW ? It should