Re: dropping an "external" table without deleting the data

… And you may want to double check your table properties using: describe formatted ; /Jerome From: Steven Wong mailto:sw...@netflix.com>> Reply-To: mailto:user@hive.apache.org>> Date: Wed, 25 Jan 2012 00:27:26 + To: "user@hive.apache.org" mailto:user@hive.apache.

Re: Running hive on large number of files in S3

Hi, I don't think that your job is actually prefetching the data while you're waiting. If you have a large number of partitions then getting the list of files to compute the split (aka prefetching the filenames from S3) is what is taking for ever. If you have a premium support from amazon you may w

Re: udf function to calculate median

Yes, the percentile function will give you the median information. /Jerome. On 2/10/11 10:16 AM, "Anurag Phadke" wrote: >Does Hive have any UDF function to calculate median for a given column? > >-anurag >