>>>>
>>>>> On Fri, Feb 14, 2014 at 4:15 PM, Nitin Pawar
>>>>> wrote:
>>>>>
>>>>>> when you are writing a file, it will need an application to create
>>>>>> and write the file.
>>>>>> Thats
>>>>
>>>>
>>>> On Fri, Feb 14, 2014 at 4:15 PM, Nitin Pawar
>>>> wrote:
>>>>
>>>>> when you are writing a file, it will need an application to create and
>>>>> write the file.
>>>>> Thats why th
>>>
>>>> Where as for other way when its displayed on console, its just hdfs cat
>>>> operation
>>>>
>>>>
>>>> On Fri, Feb 14, 2014 at 4:13 PM, Sreenath wrote:
>>>>
>>>>> i have two queries
>&
gt;
>>> Where as for other way when its displayed on console, its just hdfs cat
>>> operation
>>>
>>>
>>> On Fri, Feb 14, 2014 at 4:13 PM, Sreenath wrote:
>>>
>>>> i have two queries
>>>> 1. select * from tab1 limit 3;
>
file.
>> Thats why the mapreduce job to create the file.
>>
>> Where as for other way when its displayed on console, its just hdfs cat
>> operation
>>
>>
>> On Fri, Feb 14, 2014 at 4:13 PM, Sreenath wrote:
>>
>>> i have two queries
>>>
t 3;
>> this returns the 3 rows quickly withoput launcing any map reduce jobs;
>>
>> 2. INSERT OVERWRITE LOCAL DIRECTORY "/tmp/query1/" select * from tab1
>> limit 3;
>> but the same above query to write to a local directory launches a map
>> r
> 1. select * from tab1 limit 3;
> this returns the 3 rows quickly withoput launcing any map reduce jobs;
>
> 2. INSERT OVERWRITE LOCAL DIRECTORY "/tmp/query1/" select * from tab1
> limit 3;
> but the same above query to write to a local directory launches a map
> re
i have two queries
1. select * from tab1 limit 3;
this returns the 3 rows quickly withoput launcing any map reduce jobs;
2. INSERT OVERWRITE LOCAL DIRECTORY "/tmp/query1/" select * from tab1 limit
3;
but the same above query to write to a local directory launches a map
reduce job
erdata;
From: Felix.徐 [mailto:ygnhz...@gmail.com]
Sent: 29 May 2013 09:38
To: user@hive.apache.org
Subject: How to change the separator of INSERT OVERWRITE LOCAL DIRECTORY
Hi all,
I am wondering how to change the fields separator of INSERT OVERWRITE LOCAL
DIRECTORY , does anyone have expe
he fields separator of INSERT OVERWRITE
> LOCAL DIRECTORY , does anyone have experience doing this ? thanks!
>
--
Regards,
Ted Xu
Hi all,
I am wondering how to change the fields separator of INSERT OVERWRITE LOCAL
DIRECTORY , does anyone have experience doing this ? thanks!
rmat.
>
>
>
>
> - Original Message
> From: Jov
> To: user@hive.apache.org
> Sent: Tue, March 29, 2011 10:22:32 PM
> Subject: Re: INSERT OVERWRITE LOCAL DIRECTORY -- Why it creates multiple files
>
> try add limit:
>
> INSERT OVERWRITE LOCAL DIRE
LOCAL DIRECTORY -- Why it creates multiple files
try add limit:
INSERT OVERWRITE LOCAL DIRECTORY
'/home/hdp-user/hiveadmin_dirs/outbox/apachetest'
Select host, identity, user, time, request
from raw_apachelog
where ds = '2011-03-22-001500' limit 32;
2011/3/30 V.Senthil Ku
try add limit:
INSERT OVERWRITE LOCAL DIRECTORY
'/home/hdp-user/hiveadmin_dirs/outbox/apachetest'
Select host, identity, user, time, request
from raw_apachelog
where ds = '2011-03-22-001500' limit 32;
2011/3/30 V.Senthil Kumar :
> Hello,
>
> I have a hive query w
Hello,
I have a hive query which does a simple select and writes the results to a
local
file system.
For example, a query like this,
INSERT OVERWRITE LOCAL DIRECTORY
'/home/hdp-user/hiveadmin_dirs/outbox/apachetest'
Select host, identity, user, time, request
from raw_apachelog
15 matches
Mail list logo
