· 9 years ago · Nov 11, 2016, 11:54 PM
1"CREATE EXTERNAL TABLE IF NOT EXISTS log ( ipAddress STRING," +
2 "logLevel STRING," +
3 "userID STRING," +
4 "dateTimeString STRING," +
5 "method STRING," +
6 "endpoint STRING, " +
7 "protocol STRING," +
8 "responseCode INT," +
9 "content STRING," +
10 "trackingId STRING" +
11 ") STORED AS PARQUET LOCATION 'hdfs://X.X.X.X:54310/home/hduser/spark/testlog/'");
12
13load data inpath "hdfs://X.X.X.X:54310/home/hduser/spark/testlog/part-r-00000-29ad05a5-ca12-4332-afd0-39eb337a1acd.parquet" into table log;