Hi!

I'm trying to gather statistics for tables by using the autogather functionality. It works for the size of the table and the number of files, but when I use the ANALYZE command, it tells me 'could not update stats' and no row counts are computed. I followed the instructions on the wiki and set autogather to true, I also replaced the parameters like this:

set hive.stats.dbclass=jdbc:mysql;

set hive.stats.dbconnectionstring="jdbc:mysql://localhost/mstore";

set hive.stats.jdbcdriver="org.apache.mysql.jdbc.EmbeddedDriver";

The problem with the second parameter was that whenever I specified something after the ';' like suggested in the wiki, it threw an error. Does anyone have suggestions what might be wrong?

Thanks,
Anja

Reply via email to