Re: How to a property in hive query

set property.name=value; Thanks, Vinod On Tue, Jul 3, 2012 at 5:40 AM, Abhishek abhishek.dod...@gmail.com wrote: Hi all, Can I know, how to override a property of mapred-site.xml in Hive join query. Suppose for map reduce job we override using -D property name=value, how to do it with in

Re: How to override a property with in a hive query

What are you trying to accomplish that a method like this won't work for? On Mon, Jul 2, 2012 at 10:25 PM, Abhishek abhishek.dod...@gmail.com wrote: Hi Tim, Is this the only way, or if we have any other ways. Sent from my iPhone On Jul 2, 2012, at 8:49 PM, Tim Havens timhav...@gmail.com

Re: getting Hive table access times

Well, diving through the source code, that seems to be the case. It seems like an odd thing to have to set an access time manually, but I guess I can see how it could be useful :) On 07/02/2012 02:24 PM, VanHuy Pham wrote: I think it only makes sense to use getLastAccessTime() when you have

HQL vs. HiveQL

I have found references to both HQL and HiveQL (as abbreviations for Hive Query Language) as the name of the SQL-like language Hive uses. Is there a formal and definitively correct name in this regard or are both considered equally appropriate? I'm writing up a white paper and want to use the

Re: HQL vs. HiveQL

HQL is sometimes shortened for hibernate query languagehiveql is mapped with hive On Tue, Jul 3, 2012 at 11:29 PM, Keith Wiley kwi...@keithwiley.com wrote: I have found references to both HQL and HiveQL (as abbreviations for Hive Query Language) as the name of the SQL-like language Hive uses.

Hive insert into

Hi all, Will hive support INSERT INTO ? and It is nothing but, appending new data to the existing data.Can any one please tell me how does it happen and which version of hive supports this? Regards Abhi Sent from my iPhone

Re: Hive insert into

Abhi, Hive supports INSERT INTO syntax but you should use Hive 0.8 or higher. See https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-InsertingdataintoHiveTablesfromqueries - Youngwoo On Wed, Jul 4, 2012 at 11:19 AM, Abhishek abhishek.dod...@gmail.com wrote:

Re: Hive insert into

hi youngwoo Thanks for your reply.Can you justify your answer hdfs doesnot support append, so how hive does it? Regards Abhi On Tue, Jul 3, 2012 at 11:56 PM, 김영우 warwit...@gmail.com wrote: Abhi, Hive supports INSERT INTO syntax but you should use Hive 0.8 or higher. See

Re: Hive insert into

Hi Abhi When you say INSERT INTO in hive it needn't be a file append. In hive the data corresponding to a table/partition is in a directory, data is stored as one or more files within those. AFAIK when you do insert into, a new file is created in the directory along with old files. So hdfs

Hive upload

Hi all, I am trying to upload the tables from RDBMS to hive through sqoop, hive imports successfully. but i didn't find any table in hive that imported table gets uploaded into hdfs idr /user/hive/warehouseI want it to be present into hive, I used this command sqoop import --connect

Re: Hive upload

Hi Yogesh The first issue (sqoop one). 1) Is the table newhive coming when you list tables using 'show table'? 2) Are you seeing a directory 'newhive' in your hive warte house dir(usually /usr/hive/warehouse)? If not sqoop is failing to create hive tables /load data into them. Only sqoop