how many number of nodes you have for select query? whats your select query?
if its just a select * from table then it does not run any mapreduce job so its just taking time to show data on your screen if you are using that query On Thu, Jan 17, 2013 at 12:24 PM, venkatramanan < venkatraman...@smartek21.com> wrote: > I didnt set any hive parameters and my total table size is 610 MB only > > > > On Thursday 17 January 2013 12:11 PM, Nitin Pawar wrote: > > a bit more details on size of table and select query will help > also did you set any hive parameters ? > > > On Thu, Jan 17, 2013 at 12:12 PM, venkatramanan < > venkatraman...@smartek21.com> wrote: > >> Hi All, >> >> Am Newbie in apache hive. I have create a table and thats points to the >> HDFS Folder path and its takes 15 min to execute the simple "*select*" >> stmt, Can anyone suggest me for a best practices and performance >> improvement on hive. >> >> Thanks in Advance >> >> Venkat >> > > > > -- > Nitin Pawar > > > -- Nitin Pawar