Thanks for all your suggestions. I terminated my instances and re-launched a set of new instances. And, installed hive via apt-get. I do not see any problem now. Earlier, I had installed hive by downloading the tarball.
Interestingly, I noticed hive-site.xml file when installed through apt-get (and did not see that file when installed using tarball. Had to manually create it.). -PD. On Mon, Dec 12, 2011 at 4:27 PM, Carl Steinbach <[email protected]> wrote: > 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 <[email protected]> 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 <[email protected]> wrote: >> >>> Try file:// in front of the property value... >>> >>> Sent from my iPhone >>> >>> On Dec 12, 2011, at 12:07 AM, "Periya.Data" <[email protected]> >>> 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. >>> >>> >> >
