hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ajo Fod <ajo....@gmail.com>
Subject Re: Stats Gathering Problems
Date Fri, 04 Mar 2011 14:47:09 GMT
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.gruenheid@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&amp;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
>>>
>>
>

Mime
View raw message