Can you search your /tmp/<username>/hive.log for 'Stats' and see if there is any error message? You can also log on to mysql and see if the database you specified in the JDBC URI has been created and if there is any table in the database.
On Mar 5, 2011, at 7:35 AM, Anja Gruenheid wrote: I also tried using the original parameters from the wiki (for derby), but it gives me the same error... On 03/04/2011 05:18 PM, Anja Gruenheid wrote: I fixed the XML problem and wrote everything into hive-site.xml. The update error still exists though. Anja On 03/04/2011 09:47 AM, Ajo Fod wrote: The good news is that this is a simple XML section .. and this looks like a XML read error. Try to copy-paste one of the existing properties sections and pasting over just the name and value strings from the message. Cheers, Ajo On Fri, Mar 4, 2011 at 6:40 AM, Anja Gruenheid <anja.gruenh...@gatech.edu<mailto:anja.gruenh...@gatech.edu>> wrote: Hi! When I add this to hive-site.xml, I get the following exception when starting Hive: [Fatal Error] hive-site.xml:31:2: The markup in the document following the root element must be well-formed. Exception in thread "main" java.lang.RuntimeException: org.xml.sax.SAXParseException: The markup in the document following the root element must be well-formed. at org.apache.hadoop.conf.Configuration.loadResource(Configuration.java:1168) at org.apache.hadoop.conf.Configuration.loadResources(Configuration.java:1040) at org.apache.hadoop.conf.Configuration.getProps(Configuration.java:980) at org.apache.hadoop.conf.Configuration.get(Configuration.java:382) at org.apache.hadoop.hive.conf.HiveConf.initialize(HiveConf.java:618) at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:550) at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:431) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.hadoop.util.RunJar.main(RunJar.java:156) Caused by: org.xml.sax.SAXParseException: The markup in the document following the root element must be well-formed. It does not matter what the value is, it always throws this exception. Anja On 03/04/2011 01:48 AM, Ning Zhang wrote: Hive CLI interprete ';' as the end of a command. You should put this property in hive-site.xml: <property> <name>hive.stats.dbconnectionstring</name> <value>jdbc:mysql://localhost/mstore</value> <description>The JDBC conneciton URL. For example, jdbc:mysql:localhost/stats_db?createDatabaseIfNotExist=true&user=stat_u;password=pass</description> </property> On Mar 3, 2011, at 7:28 PM, Anja Gruenheid wrote: 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