| buyingyi | cf48fb5 | 2012-11-02 00:31:31 +0000 | [diff] [blame] | 1 | drop table IF EXISTS supplier; |
| 2 | drop table IF EXISTS result; | ||||
| 3 | |||||
| 4 | create table supplier (S_SUPPKEY array<int>, S_NAME STRING, S_ADDRESS STRING, S_NATIONKEY INT, S_PHONE STRING, S_ACCTBAL DOUBLE, S_COMMENT STRING); | ||||
| 5 | create table result (S_SUPPKEY int); | ||||
| 6 | |||||
| 7 | select s_name, s_address, col1 from supplier LATERAL VIEW explode(s_suppkey) suppadd as col1; | ||||