hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "kiranprasad" <kiranprasa...@imimobile.com>
Subject Re: When trying to create table Iam getting exception
Date Wed, 19 Oct 2011 11:09:14 GMT
Can I run HIVE in local mode, example like PIG local mode??

-----Original Message----- 
From: kiranprasad
Sent: Wednesday, October 19, 2011 3:24 PM
To: user@hive.apache.org
Subject: Re: When trying to create table Iam getting exception

PF below Hive-site.xml. there is no password for the DB.

<configuration>
<property>
<name>hive.metastore.local</name>
<value>false</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://10.0.2.65/metastore_db?createDatabaseIfNotExist=true</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
        <name>javax.jdo.option.ConnectionUserName</name>
        <value>root</value>
    </property>
    <property>
        <name>javax.jdo.option.ConnectionPassword</name>
        <value></value>
    </property>

</configuration>

-----Original Message----- 
From: Adriaan Tijsseling
Sent: Wednesday, October 19, 2011 3:19 PM
To: user@hive.apache.org
Subject: Re: When trying to create table Iam getting exception

how is your metastore set up? Looks like some incorrect or incomplete
hive-site.xml config for metatstore settings.

On 2011/10/19, at 11:38, kiranprasad wrote:

>
> Below mentioned is the table which I ve tried to create.
>
> $ bin/hive
> Hive history 
> file=/tmp/kiranprasad.g/hive_job_log_kiranprasad.g_201110191249_2139146680.txt
> hive> CREATE TABLE arpu (msisdn INT, arpu INT) ROW FORMAT DELIMITED FIELDS 
> TERMINATED BY ',' STORED AS TEXTFILE;
> FAILED: Error in metadata: java.lang.IllegalArgumentException: URI:  does 
> not have a scheme
> FAILED: Execution Error, return code 1 from 
> org.apache.hadoop.hive.ql.exec.DDLTask
>
> -----Original Message----- From: Adriaan Tijsseling
> Sent: Wednesday, October 19, 2011 3:01 PM
> To: user@hive.apache.org
> Subject: Re: When trying to create table Iam getting exception
>
> You should provide more information in order to get proper support such as 
> the exact command you used to create the table.
>
> On 2011/10/19, at 11:16, kiranprasad wrote:
>
>> Hi
>>
>> Iam new to HIVE, when trying to create a table getting below exception.
>> FAILED: Error in metadata: java.lang.IllegalArgumentException: URI:  does 
>> not have a scheme
>>
>> Regards
>> Kiran.G
>
>




Mime
View raw message