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





Reply via email to