建表语句

    1. create table call_center(
    2.       cc_call_center_sk         bigint               
    3. ,     cc_call_center_id         string              
    4. ,     cc_rec_start_date        string                         
    5. ,     cc_rec_end_date          string                         
    6. ,     cc_closed_date_sk         bigint                       
    7. ,     cc_open_date_sk           bigint                       
    8. ,     cc_name                   string                   
    9. ,     cc_class                  string                   
    10. ,     cc_employees              int                       
    11. ,     cc_sq_ft                  int                       
    12. ,     cc_hours                  string                      
    13. ,     cc_manager                string                   
    14. ,     cc_mkt_id                 int                       
    15. ,     cc_mkt_class              string                      
    16. ,     cc_mkt_desc               string                  
    17. ,     cc_market_manager         string                   
    18. ,     cc_division               int                       
    19. ,     cc_division_name          string                   
    20. ,     cc_company                int                       
    21. ,     cc_company_name           string                      
    22. ,     cc_street_number          string                      
    23. ,     cc_street_name            string                   
    24. ,     cc_street_type            string                      
    25. ,     cc_suite_number           string                      
    26. ,     cc_city                   string                   
    27. ,     cc_county                 string                   
    28. ,     cc_state                  string                       
    29. ,     cc_zip                    string                      
    30. ,     cc_country                string                   
    31. ,     cc_gmt_offset             double                  
    32. ,     cc_tax_percentage         double
    33. ,     PRIMARY KEY(cc_call_center_sk)
    34. )
    35. PARTITION BY HASH PARTITIONS 16
    36. STORED AS KUDU;

    hive 导 kudu

    1. INSERT INTO call_center SELECT * FROM test_tpc_ds.call_center;