Home | About | Sematext search-lucene.com search-hadoop.com
 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

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


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