Hi Periya, You should only set the hive.metastore.uris property if you are running a standalone MetaStore server, in which case you need to set hive.metastore.local=false and set hive.metastore.uris to a Thrift URI. Please see this document for more details:
https://cwiki.apache.org/confluence/display/Hive/AdminManual+MetastoreAdmin Thanks. Carl On Sun, Dec 11, 2011 at 10:36 PM, Kirk True <k...@mustardgrain.com> wrote: > To me it looks like the error message is getting a blank for the URI > property value. Can you triple-check the property _name_ is correct > (including capitalization)? > > > On 12/11/11 9:35 PM, Periya.Data wrote: > > Sam: I added "file://". Now it looks like this: > <value>file:///home/users/jtv/CDH3/hive/conf/metastore_db</value> > > The problem has not gone away. I still have the same problem. I tried > rebooting my ec-2 instance. Still no difference. > > What does it mean by "does not have a scheme". What is it expecting? > > Thanks, > PD. > > On Sun, Dec 11, 2011 at 9:15 PM, Sam Wilson <swil...@monetate.com> wrote: > >> Try file:// in front of the property value... >> >> Sent from my iPhone >> >> On Dec 12, 2011, at 12:07 AM, "Periya.Data" <periya.d...@gmail.com> >> wrote: >> >> Hi, >> I am trying to create Hive tables on an EC2 instance. I get this >> strange error about URI schema and log4j properties not found. I do not >> know how to fix this. >> >> On EC2 instance : Ubuntu 10.04, Hive-0.7.1-cdh3u2. >> >> Initially I did not have an entry for hive.metastore.uris property in my >> hive-default.xml file. So, I created one. Still, I get the errors as >> pasted below. I was under the assumption that if we leave the uris value >> blank, it is will assume the local metastore. >> >> <property> >> <name>hive.metastore.local</ >> name> >> <value>true</value> >> <description>controls whether to connect to remove metastore server or >> open a new metastore server in Hive Client JVM</description> >> </property> >> >> <property> >> <name>hive.metastore.uris</name> >> <value>/home/users/jtv/CDH3/hive/conf/metastore_db</value> >> </property> >> >> >> root@ip-10-114-18-63:/home/users/jtv# hive -f ./scripts/log25.q >> hive-log4j.properties not found >> Hive history file=/tmp/root/hive_job_log_root_201112120332_1795396613.txt >> 11/12/12 03:32:03 INFO exec.HiveHistory: Hive history >> file=/tmp/root/hive_job_log_root_201112120332_1795396613.txt >> 11/12/12 03:32:03 INFO parse.ParseDriver: Parsing command: CREATE TABLE >> log25_tbl (OperationEvent STRING, HostIP STRING, StartTime STRING, >> SourceRepo STRING, SourceFolder STRING, DestRepo STRING, DestFolder STRING, >> EntityOrObject STRING, BytesSent STRING, TotalTimeInSecs STRING) COMMENT >> 'This is the Log_25 Table' >> 11/12/12 03:32:04 INFO parse.ParseDriver: Parse Completed >> 11/12/12 03:32:04 INFO parse.SemanticAnalyzer: Starting Semantic Analysis >> 11/12/12 03:32:04 INFO parse.SemanticAnalyzer: Creating table log25_tbl >> position=13 >> 11/12/12 03:32:04 INFO ql.Driver: Semantic Analysis Completed >> 11/12/12 03:32:04 INFO ql.Driver: Returning Hive schema: >> Schema(fieldSchemas:null, properties:null) >> 11/12/12 03:32:04 INFO ql.Driver: Starting command: CREATE TABLE >> log25_tbl (OperationEvent STRING, HostIP STRING, StartTime STRING, >> SourceRepo STRING, SourceFolder STRING, DestRepo STRING, DestFolder STRING, >> EntityOrObject STRING, BytesSent STRING, TotalTimeInSecs STRING) COMMENT >> 'This is the Log_25 Table' >> 11/12/12 03:32:04 INFO exec.DDLTask: Default to LazySimpleSerDe for table >> log25_tbl >> 11/12/12 03:32:04 INFO hive.log: DDL: struct log25_tbl { string >> operationevent, string hostip, string starttime, string sourcerepo, string >> sourcefolder, string destrepo, string destfolder, string entityorobject, >> string bytessent, string totaltimeinsecs} >> FAILED: Error in metadata: java.lang.IllegalArgumentException: URI: does >> not have a scheme >> 11/12/12 03:32:04 ERROR exec.DDLTask: FAILED: Error in metadata: >> java.lang.IllegalArgumentException: URI: does not have a scheme >> org.apache.hadoop.hive.ql.metadata.HiveException: >> java.lang.IllegalArgumentException: URI: does not have a scheme >> at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:476) >> at >> org.apache.hadoop.hive.ql.exec.DDLTask.createTable(DDLTask.java:3176) >> at org.apache.hadoop.hive.ql.exec.DDLTask.execute(DDLTask.java:213) >> at org.apache.hadoop.hive.ql.exec.Task.executeTask(Task.java:130) >> at >> org.apache.hadoop.hive.ql.exec.TaskRunner.runSequential(TaskRunner.java:57) >> at org.apache.hadoop.hive.ql.Driver.launchTask(Driver.java:1063) >> at org.apache.hadoop.hive.ql.Driver.execute(Driver.java:900) >> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:748) >> at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:209) >> at >> org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:286) >> at >> org.apache.hadoop.hive.cli.CliDriver.processReader(CliDriver.java:310) >> at >> org.apache.hadoop.hive.cli.CliDriver.processFile(CliDriver.java:317) >> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:490) >> 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: java.lang.IllegalArgumentException: URI: does not have a >> scheme >> at >> org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:127) >> at >> org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:1868) >> at org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:1878) >> at org.apache.hadoop.hive.ql.metadata.Hive.createTable(Hive.java:470) >> ... 17 more >> >> FAILED: Execution Error, return code 1 from >> org.apache.hadoop.hive.ql.exec.DDLTask >> 11/12/12 03:32:04 ERROR ql.Driver: FAILED: Execution Error, return code 1 >> from org.apache.hadoop.hive.ql.exec.DDLTask >> root@ip-10-114-18-63:/home/users/jtv# >> =================================== >> >> Suggestions are appreciated. >> >> PD. >> >> >
