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.
> 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:
>> We could not overwrite a file inside hive table folder. What is the command to over write it.