RE: Hive script auto completion and semantic analyzer?

2015-01-08 Thread Xiaoyong Zhu
Could someone share some insights on this...? Xiaoyong From: Xiaoyong Zhu [mailto:xiaoy...@microsoft.com] Sent: Thursday, January 8, 2015 3:01 PM To: user@hive.apache.org Cc: Yifung Lin; Zhaomin Xu Subject: Hive script auto completion and semantic analyzer? Hi, hive experts We are building a

Re: How to convert RDBMS DDL to Hive DDL ?

2015-01-08 Thread Sanjay Subramanian
@Krishare u looking for an automated tool that takes RDBMS DDL as input and outputs Hive DDL ?I exported the DDLS of all tables with col sequence numbersI wrote code that converted all DB2 tables we have to Hive. Not sure if there is a standard tool. regards sanjay From: Lefty Leverenz

hive metastore service uses

2015-01-08 Thread Bharath Kumar
Hi Team, I fail to understand what is the use of hive metastore service when hive service can connect to metastore directly using jdbc ? -- Warm Regards, *Bharath Kumar *

Need write access to Apache Hive confluence

2015-01-08 Thread Anilkumar Kalshetti
Hi, I need write access to Apache Hive confluence. My confluence user id is: *anilkalshetti* Regards, Anil

how to get hive script output/logs via HDFS/WebHCat?

2015-01-08 Thread Xiaoyong Zhu
Hi experts I don't know if there is a way to get the hive script output and result programmatically as well as remotely? For example, after using WebHCat to submit a query: describe databases; I want to get the logs: 15/01/08 23:52:34 WARN conf.HiveConf: DEPRECATED: hive.metastore.ds.retry.*

Using IF in the JOIN clause

2015-01-08 Thread Sanjay Subramanian
hey guys This is a portion of a long query we wrote.Can u advise if the bold portion will work ?     and if(f.fr_name is not null, f.fr_name, e.fr_name)=d.fr_name     and if(f.pos_bin is not null, f.pos_bin, e.pos_bin)=d.pos_bin  thanksregards sanjay PART OF A LARGER

hive mail list search link is wrong?

2015-01-08 Thread Xiaoyong Zhu
The link for mark mail in this page (http://hive.apache.org/mailing_lists.html#Users ) is http://markmail.org/search/+list:org.apache.incubator.hive-user which I think is wrong - it returns no result. I searched in markmail again and removed the incubator work, then I can search all the

How to convert RDBMS DDL to Hive DDL ?

2015-01-08 Thread Krish Donald
Hi, I am new to hive and I have imported data into HDFS using DB2. Now I want to create hive table. I am not sure How to convert RDBMS DDL to Hive DDL ? Can somebody please guide ? Thanks Krish