Re: Hive Statistics information

2013-09-03 Thread Sanjay Subramanian
e.org<mailto:user@hive.apache.org>" mailto:user@hive.apache.org>> Subject: Re: Hive Statistics information Hi Sanjay, What do the logs say when you fire the ANALYZE TABLE... statement on a table ? One minor correction to the db connectionstring would be to use & for the quer

Re: Hive Statistics information

2013-08-30 Thread Ravi Kiran
Hi Sanjay, What do the logs say when you fire the ANALYZE TABLE... statement on a table ? One minor correction to the db connectionstring would be to use & for the query parameters. hive.stats.dbconnectionstring=jdbc:mysql:// v-so1.nextagqa.com/hive_vso1_tempstatsstore?user=hive_user_vso1&

Hive Statistics information

2013-08-30 Thread Sanjay Subramanian
Hi guys I have configured Hive to use MySQL for all statistics hive.stats.atomic=false hive.stats.autogather=true hive.stats.collect.rawdatasize=true hive.stats.dbclass=jdbc:mysql hive.stats.dbconnectionstring=jdbc:mysql://v-so1.nextagqa.com/hive_vso1_tempstatsstore?&user=hive_user_vso1&password=