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
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
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
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
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
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
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
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