CREATE TABLE wordcount .hljs-operator[(]token STRING.hljs-operator[);] LOAD DATA LOCAL .hljs-keyword[INPATH] .hljs-string[’wordcount/words’] .hljs-keyword[OVERWRITE] INTO TABLE wordcount.hljs-operator[;] SELECT count.hljs-operator[(*)] FROM wordcount GROUP BY token.hljs-operator[;]
SELECT [.hljs-keyword[ALL] | DISTINCT] select_expr.hljs-operator[,] select_expr.hljs-operator[,] ... FROM table_reference [WHERE where_condition] [GROUP BY col_list] [HAVING having_condition] [ORDER BY col_list] [LIMIT number] .hljs-operator[;]