Re: Stats Gathering Problems

2011-03-05 Thread Anja Gruenheid
I tried to use the default settings and with that it works (at least it doesn't throw an error). What's weird is that it collects the data on files/files size etc., but it doesn't compute the row count. Do you have any idea why that could be? The table is based on a textfile and is handled as m

Re: Stats Gathering Problems

2011-03-05 Thread Ning Zhang
Can you search your /tmp//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 us

Re: Stats Gathering Problems

2011-03-05 Thread Anja Gruenheid
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 wr

Re: Stats Gathering Problems

2011-03-04 Thread Anja Gruenheid
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 sect

Re: Stats Gathering Problems

2011-03-04 Thread Ajo Fod
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 wrote: > Hi! > > Wh

Re: Stats Gathering Problems

2011-03-04 Thread Anja Gruenheid
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 marku

Re: Stats Gathering Problems

2011-03-03 Thread Ning Zhang
Hive CLI interprete ';' as the end of a command. You should put this property in hive-site.xml: hive.stats.dbconnectionstring jdbc:mysql://localhost/mstore The JDBC conneciton URL. For example, jdbc:mysql:localhost/stats_db?createDatabaseIfNotExist=true&user=stat_u;password=pass On Mar

Stats Gathering Problems

2011-03-03 Thread Anja Gruenheid
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 a