[GitHub] [hudi] rubenssoto commented on issue #3966: [SUPPORT] Hudi Sync Remote Hive - EKS

[GitBox]

rubenssoto commented on issue #3966:
URL: https://github.com/apache/hudi/issues/3966#issuecomment-965906492


   I have no problems to create and query tables in hive using spark
   
   ```
   from os.path import expanduser, join, abspath
   from pyspark.sql import SparkSession
   from pyspark.sql import Row
   
   # warehouse_location points to the default location for managed databases 
and tables
   warehouse_location = abspath('spark-warehouse')
   
   spark = SparkSession \
       .builder \
       .appName("Python Spark SQL Hive integration example") \
       .enableHiveSupport() \
       .config("hive.metastore.uris", 
"thrift://hive-metastore.hive.svc.cluster.local:9083") \
       .enableHiveSupport() \
       .getOrCreate()
   
   
   spark.sql("create table test_metastore(a int,b int);")
   
   spark.sql("select count(1) from test_metastore").show()
   ```
   
   <img width="1583" alt="Captura de Tela 2021-11-10 às 22 18 28" 
src="https://user-images.githubusercontent.com/36298331/141219711-a02a167b-c657-4087-a59b-a18f175d07ba.png";>
   <img width="1519" alt="Captura de Tela 2021-11-10 às 22 17 21" 
src="https://user-images.githubusercontent.com/36298331/141219715-61f484a1-8a7a-46cd-9fe8-678827aa2108.png";>
   


-- 
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: commits-unsubscr...@hudi.apache.org

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