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