I'm executing this example from the documentation (in single node mode) # sc is an existing SparkContext. from pyspark.sql import HiveContext sqlContext = HiveContext(sc)
sqlContext.sql("CREATE TABLE IF NOT EXISTS src (key INT, value STRING)") # Queries can be expressed in HiveQL. results = sqlContext.sql("FROM src SELECT key, value").collect() 1. would it be possible to get the results from collect in a more human-readable format? For example, I would like to have a result similar to what I would get using hive CLI. 2. The first query does not seem to create the table. I tried "show tables;" from hive after doing it, and the table src did not show up.