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 <liy...@gmail.com> 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 > <ramasubramanian.naraya...@gmail.com> wrote: >> Hi, >> >> We could not overwrite a file inside hive table folder. What is the command >> to over write it. >> >> Regards, >> Rams
