title: Register Delta table in Hive metastore error
body: <p>I need to register Delta table in Hive metastore to be able to query it using external reporting tool connecting to ThriftServer</p>
  
  <p>PySpark API works well, I am able to create DeltaTable object</p>
  
  <pre><code>ordersDeltaTable = DeltaTable.forPath(spark, delta_path)
  </code></pre>
  
  <p>When I am running SQL command </p>
  
  <pre><code>%%sql
  CREATE TABLE orders_delta
  USING DELTA
  LOCATION '/tmp/orders/delta/'
  </code></pre>
  
  <p>or </p>
  
  <pre><code>spark.sql("CREATE TABLE orders_delta USING delta LOCATION '/tmp/orders/delta/'")
  </code></pre>
  
  <p>or this one</p>
  
  <pre><code>%%sql
  CREATE TABLE orders_delta
  USING delta
  AS SELECT *
  FROM csv.`s3://orders/raw/public/order_items/`
  </code></pre>
  
  <p>I always have the same exception</p>
  
  <pre><code>An error was encountered:
  u'Can not create a Path from an empty string'
  Traceback (most recent call last):
    File "/usr/lib/spark/python/lib/pyspark.zip/pyspark/sql/session.py", 
  line 767, in sql
      return DataFrame(self._jsparkSession.sql(sqlQuery), self._wrapped)
    File "/usr/lib/spark/python/lib/py4j-0.10.7- 
     src.zip/py4j/java_gateway.py", line 1257, in __call__
      answer, self.gateway_client, self.target_id, self.name)
    File "/usr/lib/spark/python/lib/pyspark.zip/pyspark/sql/utils.py", 
  line 79, in deco
      raise IllegalArgumentException(s.split(': ', 1)[1], stackTrace)
  IllegalArgumentException: u'Can not create a Path from an empty 
  string'
  </code></pre>
  
  <p>I am using</p>
  
  <p>EMR 5.27.0
  Spark 2.4.4
  Hive 2.3.5 
  delta-core_2.11-0.4.0.jar
  with Jupyter Notebook.</p>
  
  <p>Is there any other way to regiser DeltaTable in Hive metastore?</p>