AE
Size: a a a
AE
Н
df.write.mode("overwrite").format("parquet").saveAsTable("xxxx.yyyy")
pyspark.sql.utils.AnalysisException: u"Database 'xxxx' not found;"
spark = (
SparkSession.builder.appName("Event Sale: Creating parquet table")
# .config("spark.sql.warehouse.dir", "/user/hive/warehouse")
# .config("hive.metastore.warehouse.dir", "/user/hive/warehouse")
.enableHiveSupport()
.getOrCreate()
)
spark.sql("show databases").show()
M
Н
sqlContext = HiveContext(spark)20/02/26 15:41:16 WARN metastore.ObjectStore: Failed to get database global_temp, returning NoSuchObjectException
sqlContext.tables().show()
M
Н
M
Н
M
Н
Н
>>> spark.catalog.listDatabases()
[Database(name=u'default', description=u'Default Hive database', locationUri=u'file:/usr/local/airflow/spark-warehouse')]
Н
M
A
VZ
AC
AC
BK
BK
R