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&password=hive_user_vso1<http://v-so1.nextagqa.com/hive_vso1_tempstatsstore?&user=hive_user_vso1&password=hive_user_vso1>
I hope the database hive_vso1_tempstatsstore<http://v-so1.nextagqa.com/hive_vso1_tempstatsstore?&user=hive_user_vso1&password=hive_user_vso1>exists in your MySQL? Regards Ravi Magham On Sat, Aug 31, 2013 at 6:15 AM, Sanjay Subramanian < [email protected]> wrote: > 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=hive_user_vso1 > hive.stats.jdbc.timeout=30 > hive.stats.jdbcdriver=com.mysql.jdbc.Driver > hive.stats.retries.max=0 > hive.stats.retries.wait=3000 > > However in the MYSQL hive statistics tables , they don't seem to have > any data ? > > Where does Hive store the statistics information ? > > sanjay > > CONFIDENTIALITY NOTICE > ====================== > This email message and any attachments are for the exclusive use of the > intended recipient(s) and may contain confidential and privileged > information. Any unauthorized review, use, disclosure or distribution is > prohibited. If you are not the intended recipient, please contact the > sender by reply email and destroy all copies of the original message along > with any attachments, from your computer system. If you are the intended > recipient, please be advised that the content of this message is subject to > access, review and disclosure by the sender's Email System Administrator. >
