close Warning: Can't synchronize with repository "(default)" (Unsupported version control system "svn": /usr/lib/python2.7/dist-packages/libsvn/_fs.so: failed to map segment from shared object: Cannot allocate memory). Look in the Trac log for more information.

Changes between Version 10 and Version 11 of waue/2009/0506


Ignore:
Timestamp:
May 6, 2009, 5:11:01 PM (17 years ago)
Author:
waue
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • waue/2009/0506

    v10 v11  
    3737
    3838 * 執行
     39
    3940{{{
    4041hive> CREATE TABLE invites (foo INT, bar STRING) PARTITIONED BY (ds STRING);
    … …  
    4849
    4950 * 執行
     51
    5052{{{
    5153hive> SHOW TABLES;
    … …  
    6062
    6163 * 執行
     64
    6265{{{
    6366hive> DESCRIBE invites;
    … …  
    7477
    7578 * 執行
     79
    7680{{{
    7781hive> ALTER TABLE pokes ADD COLUMNS (new_col INT);
    … …  
    8589
    8690 * 執行
     91
    8792{{{
    8893hive> ALTER TABLE invites ADD COLUMNS (new_col2 INT COMMENT 'a comment');
    … …  
    96101
    97102 * 執行
     103
    98104{{{
    99105hive> LOAD DATA LOCAL INPATH './examples/files/kv1.txt'
    … …  
    110116
    111117 * 執行
     118
    112119{{{
    113120hive> LOAD DATA LOCAL INPATH './examples/files/kv2.txt'
    … …  
    124131
    125132 * 執行
     133
    126134{{{
    127135hive> LOAD DATA LOCAL INPATH './examples/files/kv3.txt'
    … …  
    138146
    139147 * 執行
     148
    140149{{{
    141150hive> INSERT OVERWRITE DIRECTORY '/tmp/hdfs_out'
    … …  
    158167
    159168 * 執行
     169
    160170{{{
    161171hive> select count(1) from pokes;
    … …  
    189199
    190200 * 執行
     201
    191202{{{
    192203hive> INSERT OVERWRITE DIRECTORY '/tmp/hdfs_out' SELECT a.* FROM invites a;
    … …  
    208219
    209220 * 執行
     221
    210222{{{
    211223hive>  INSERT OVERWRITE DIRECTORY '/tmp/reg_5' SELECT COUNT(1) FROM invites a;