I've used the following: Insert overwrite tbl select * from tbl where col1 = 'fake value'
On 4/25/09, Suhail Doshi <[email protected]> wrote: > Hello, > > Is there a way to truncate a table instead of dropping it and the creating > it again? I've been looking through the docs and haven't found anything. > > Suhail > > -- > http://mixpanel.com > Blog: http://blog.mixpanel.com >
