The simple use of Spark learning spark-sql.sh

Start Hadoop and start Spark.

Build a simple test data customers.txt, for convenience, I put it in the Spark/bin directory:

John Smith, Austin, TX, 78727200, Joe Johnson, Dallas, TX, 75201300, Bob Jones, Houston, TX, 77028400, Andy Davis, Sa n Antonio, TX, 78227500, James Williams, Austin, TX, 78727

Start Spark-sql:

./spark-sql.sh

　　

Map data into a database table:

Load data:

Load data local inpath './customers.txt ' overwrite into table Customer;

Query data:

SELECT * from Customer;

　　

Finish!

The simple use of Spark learning spark-sql.sh