Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> How to overwrite a file inside hive table folder


Copy link to this message
-
Re: How to overwrite a file inside hive table folder
Hi,

I think you could try to drop partition and create a new partition if
you table is partitioned

Ruslan

On Mon, Sep 17, 2012 at 8:12 AM, MiaoMiao <[EMAIL PROTECTED]> wrote:
> What do you mean by "a file"? If your HDFS dir contains several file
> and you want to overwrite one, then no way you can do it with HiveQL.
> You can check out this link and see if it suits you.
>
> https://cwiki.apache.org/Hive/languagemanual-dml.html#LanguageManualDML-Writingdataintofilesystemfromqueries
>
> My way of exporting hiveql result as a single is this:
> echo "some,column,name">some.file
> hive -S -e "select some, column, name from some_table"|sed -e
> "s/\t/,/" >> some.file
> On Sun, Sep 16, 2012 at 12:17 AM, Ramasubramanian
> <[EMAIL PROTECTED]> wrote:
>> Hi,
>>
>> We could not overwrite a file inside hive table folder. What is the command to over write it.
>>
>> Regards,
>> Rams
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB