You are viewing a plain text version of this content. The canonical link for it is here.

Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2022/08/27 18:34:08 UTC

[GitHub] [arrow-ballista] andygrove commented on issue #166: Add support for `CREATE EXTERNAL TABLE` from Python

andygrove commented on issue #166:
URL: https://github.com/apache/arrow-ballista/issues/166#issuecomment-1229242626

   It actually does work but we get an error if we try and show the results of the DataFrame. This is not good UX so we will need to fix.
   
   ```
   >>> import ballista
   >>> ctx = ballista.BallistaContext("localhost", 50050)
   >>> ctx.sql("CREATE EXTERNAL TABLE orders STORED AS PARQUET LOCATION '/mnt/bigdata/tpch/sf1-parquet/orders'")
   <ballista.DataFrame object at 0x7f501f088150>
   >>> df = ctx.sql("SELECT count(*) FROM orders")
   >>> df.show()
   +-----------------+
   | COUNT(UInt8(1)) |
   +-----------------+
   | 14999999        |
   +-----------------+
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org