https://community.cloudera.com/t5/Support-Questions/FAILED-SemanticException-org-apache-hadoop-hive-ql-parse/m-p/192542#M154610 <P>I was following the tutorial to create a table Truck_Mileage from Existing Trucking Data, using the Ambari Hive View 2.0, executing the following query (see attachment). However, received a status 500 error. Please see attachment for details. Any ideas? </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="64831-hortonworks-query-failed.png" style="width: 1898px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/18288i2620B6F77F286934/image-size/medium?v=v2&amp;px=400" role="button" title="64831-hortonworks-query-failed.png" alt="64831-hortonworks-query-failed.png" /></span></P><H3 id="toc-hId-1427814696"></H3><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="64829-hortonworks-query.png" style="width: 798px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/18289i08A9B42EE4D39B82/image-size/medium?v=v2&amp;px=400" role="button" title="64829-hortonworks-query.png" alt="64829-hortonworks-query.png" /></span></P> Sun, 18 Aug 2019 07:10:36 GMT cathyjliu 2019-08-18T07:10:36Z https://community.cloudera.com/t5/Support-Questions/FAILED-SemanticException-org-apache-hadoop-hive-ql-parse/m-p/192542#M154610 <P>I was following the tutorial to create a table Truck_Mileage from Existing Trucking Data, using the Ambari Hive View 2.0, executing the following query (see attachment). However, received a status 500 error. Please see attachment for details. Any ideas? </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="64831-hortonworks-query-failed.png" style="width: 1898px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/18288i2620B6F77F286934/image-size/medium?v=v2&amp;px=400" role="button" title="64831-hortonworks-query-failed.png" alt="64831-hortonworks-query-failed.png" /></span></P><H3 id="toc-hId-1427814696"></H3><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="64829-hortonworks-query.png" style="width: 798px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/18289i08A9B42EE4D39B82/image-size/medium?v=v2&amp;px=400" role="button" title="64829-hortonworks-query.png" alt="64829-hortonworks-query.png" /></span></P> Sun, 18 Aug 2019 07:10:36 GMT https://community.cloudera.com/t5/Support-Questions/FAILED-SemanticException-org-apache-hadoop-hive-ql-parse/m-p/192542#M154610 cathyjliu 2019-08-18T07:10:36Z https://community.cloudera.com/t5/Support-Questions/FAILED-SemanticException-org-apache-hadoop-hive-ql-parse/m-p/192543#M154611 <P><A rel="user" href="https://community.cloudera.com/users/17892/cathyjliu.html" nodeid="17892">@Cathy Liu</A></P><P>The table you are trying to create already exists <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>Either use the existing table or drop the table and recreate it if you want it afresh!</P><P>Let know if you need any other help.</P> Mon, 26 Mar 2018 04:39:04 GMT https://community.cloudera.com/t5/Support-Questions/FAILED-SemanticException-org-apache-hadoop-hive-ql-parse/m-p/192543#M154611 RahulSoni 2018-03-26T04:39:04Z https://community.cloudera.com/t5/Support-Questions/FAILED-SemanticException-org-apache-hadoop-hive-ql-parse/m-p/192544#M154612 <P>Thank you; figured that out as I was going through the tutorial.</P> Mon, 26 Mar 2018 10:10:55 GMT https://community.cloudera.com/t5/Support-Questions/FAILED-SemanticException-org-apache-hadoop-hive-ql-parse/m-p/192544#M154612 cathyjliu 2018-03-26T10:10:55Z