title: PrestoDB Hive Catalog: no viable alternative at input 'CREATE EXTERNAL'
body: <p>I am running a query in Teradata PrestoDB distribution  for Hive <code>catalog</code> as:</p>
  
  <pre><code>CREATE EXTERNAL TABLE hive.default.mydata
  id INT, datetime timestamp, latitude FLOAT,
  longitude FLOAT, bookingid VARCHAR, pre_lat FLOAT,
  pre_long FLOAT, time_hour decimal(6, 1), dist_kms decimal(6, 1),
  ma6_dist_kms decimal(6, 1), istationary INT, quality_overall VARCHAR,
  quality_nonstationary VARCHAR, cartype VARCHAR, isbigloss INT,
  bookregion VARCHAR, iho_road VARCHAR)
  STORED AS PARQUET
  LOCATION "s3://sb.mycompany.com/someFolder/anotherFolder";
  </code></pre>
  
  <p>Throwing following exception:</p>
  
  <pre><code>Query 20180316_022346_00001_h9iie failed: line 1:8: no viable alternative at input 'CREATE EXTERNAL'
  </code></pre>
  
  <p>Even when I use hive and run a show table command, I see an error as <strong>Schema is set but catalog is not</strong>:</p>
  
  <pre><code>presto&gt; use hive;
  presto:hive&gt; show tables;
  Error running command:
  Error starting query at http://localhost:8080/v1/statement returned HTTP response code 400.
  Response info:
  JsonResponse{statusCode=400, statusMessage=Bad Request, headers={Content-Length=[32], Date=[Fri, 16 Mar 2018 02:25:25 GMT], Content-Type=[text/plain]}, hasValue=false, value=null}
  Response body:
  Schema is set but catalog is not
  </code></pre>
  
  <p>Any help would be appreciated. Thanks.</p>