https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111829#M74677 <P>Thank you. I ran the above command and I am getting the below lines. Connecting to jdbc:hive2://:10000/default?hive.execution.engine=tez</P><PRE>Error: Bad URL format. Hostname not found in authority part of the url: :10000. Are you missing a '/' after the hostname ? (state=,code=0) Beeline version 1.2.1.2.3.2.0-2950 by Apache Hive 0: jdbc:hive2://:10000/default (closed)&gt; Is this Error normal?</PRE> Fri, 22 Apr 2016 22:01:07 GMT Eukrev 2016-04-22T22:01:07Z https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111821#M74669 <P>Hi,</P><P>Is this error a common one or specific to a user. I am getting this since morning. Could you please resolve this. Thank you.</P> Fri, 22 Apr 2016 20:16:47 GMT https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111821#M74669 Eukrev 2016-04-22T20:16:47Z https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111822#M74670 <P>If this is in Hive View, did you try to log out and log in again?</P> Fri, 22 Apr 2016 20:19:03 GMT https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111822#M74670 bwalter1 2016-04-22T20:19:03Z https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111823#M74671 <P>I restarted several time and get the error: Metastore on sandbox.hortonworks.com failed (Execution of 'export HIVE_CONF_DIR='/usr/hd</P> Fri, 22 Apr 2016 20:24:22 GMT https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111823#M74671 Eukrev 2016-04-22T20:24:22Z https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111824#M74672 <P>Yes. 3 to 4 times. restarted several times. Could you pls help. Metastore on sandbox.hortonworks.com failed (Execution of 'export HIVE_CONF_DIR='/usr/hd</P> Fri, 22 Apr 2016 20:25:20 GMT https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111824#M74672 Eukrev 2016-04-22T20:25:20Z https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111825#M74673 <P>Under sandbox.hortonworks.com, Host HiveMetastore and Hive server are in started status.</P> Fri, 22 Apr 2016 20:28:16 GMT https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111825#M74673 Eukrev 2016-04-22T20:28:16Z https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111826#M74674 <P>Hi Bernhard, Is there anyother was to work in Hive?</P> Fri, 22 Apr 2016 20:34:52 GMT https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111826#M74674 Eukrev 2016-04-22T20:34:52Z https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111827#M74675 <P>Have you tried restarting ambari-server (command line as root: "ambari-server restart"). This the JVM where I think the Hive views runs in ...</P> Fri, 22 Apr 2016 21:28:54 GMT https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111827#M74675 bwalter1 2016-04-22T21:28:54Z https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111828#M74676 <P>And if you just want to quickly see whether hive works you can use command line beeline:</P><PRE>beeline -u jdbc:hive2://$HIVE_SERVER:10000/default?hive.execution.engine=tez -n hive</PRE> Fri, 22 Apr 2016 21:32:54 GMT https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111828#M74676 bwalter1 2016-04-22T21:32:54Z https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111829#M74677 <P>Thank you. I ran the above command and I am getting the below lines. Connecting to jdbc:hive2://:10000/default?hive.execution.engine=tez</P><PRE>Error: Bad URL format. Hostname not found in authority part of the url: :10000. Are you missing a '/' after the hostname ? (state=,code=0) Beeline version 1.2.1.2.3.2.0-2950 by Apache Hive 0: jdbc:hive2://:10000/default (closed)&gt; Is this Error normal?</PRE> Fri, 22 Apr 2016 22:01:07 GMT https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111829#M74677 Eukrev 2016-04-22T22:01:07Z https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111830#M74678 <P>Set the environment variable HIVE_SERVER to your hive server machine, or use</P><PRE>beeline -u jdbc:hive2://this.is.my.hiveserver.name:10000/default?hive.execution.engine=tez -n hive</PRE> Fri, 22 Apr 2016 22:08:39 GMT https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111830#M74678 bwalter1 2016-04-22T22:08:39Z https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111831#M74679 <P>I tried "ambari-server restart". Restart was successful, but the stacks wasn't up. I restart all the components.</P><P>And Thank you. Hive is up. </P> Fri, 22 Apr 2016 22:14:25 GMT https://community.cloudera.com/t5/Support-Questions/Hive-error-H110-Unable-to-submit-statement-Invalid/m-p/111831#M74679 Eukrev 2016-04-22T22:14:25Z