[Spark][Hive][Python][SQL]Spark 读取Hive表的小例子
[Spark][Hive][Python][SQL]Spark 读取Hive表的小例子 $ cat customers.txt 1 Ali us 2 Bsb ca 3 Carls mx $ hive hive> > CREATE TABLE IF NOT EXISTS customers( > cust_id string, > name string, > country string > ) > ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'; hive> load data local inpath '/home/training/customers.txt' into table customers; hive>exit $pyspark sqlContext =HiveContext(sc) filterDF=sqlContext.sql(""" SELECT * FROM customers WHERE name LIKE "A%" """) filterDF.limit(3...