PageRenderTime 39ms CodeModel.GetById 15ms RepoModel.GetById 0ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out

#
text | 78 lines | 73 code | 5 blank | 0 comment | 0 complexity | db906efaa2f1b1aaddd72af353976ba0 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: EXPLAIN
    2. 

  2. CREATE TABLE dest1(key INT, value STRING) STORED AS
    3. 

  3.   INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
    4. 

  4.   OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
    5. 

  5. PREHOOK: type: CREATETABLE
    6. 

  6. POSTHOOK: query: EXPLAIN
    7. 

  7. CREATE TABLE dest1(key INT, value STRING) STORED AS
    8. 

  8.   INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
    9. 

  9.   OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
    10. 

  10. POSTHOOK: type: CREATETABLE
    11. 

  11. ABSTRACT SYNTAX TREE:
    12. 

  12.   (TOK_CREATETABLE (TOK_TABNAME dest1) TOK_LIKETABLE (TOK_TABCOLLIST (TOK_TABCOL key TOK_INT) (TOK_TABCOL value TOK_STRING)) (TOK_TABLEFILEFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat' 'org.apache.hadoop.mapred.SequenceFileOutputFormat'))
    13. 

  13. 

  14. STAGE DEPENDENCIES:
    15. 

  15.   Stage-0 is a root stage
    16. 

  16. 

  17. STAGE PLANS:
    18. 

  18.   Stage: Stage-0
    19. 

  19.       Create Table Operator:
    20. 

  20.         Create Table
    21. 

  21.           columns: key int, value string
    22. 

  22.           if not exists: false
    23. 

  23.           input format: org.apache.hadoop.mapred.SequenceFileInputFormat
    24. 

  24.           # buckets: -1
    25. 

  25.           output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
    26. 

  26.           name: dest1
    27. 

  27.           isExternal: false
    28. 

  28. 

  29. 

  30. PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS
    31. 

  31.   INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
    32. 

  32.   OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
    33. 

  33. PREHOOK: type: CREATETABLE
    34. 

  34. POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS
    35. 

  35.   INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
    36. 

  36.   OUTPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileOutputFormat'
    37. 

  37. POSTHOOK: type: CREATETABLE
    38. 

  38. POSTHOOK: Output: default@dest1
    39. 

  39. PREHOOK: query: DESCRIBE EXTENDED dest1
    40. 

  40. PREHOOK: type: DESCTABLE
    41. 

  41. POSTHOOK: query: DESCRIBE EXTENDED dest1
    42. 

  42. POSTHOOK: type: DESCTABLE
    43. 

  43. key	int	
    44. 

  44. value	string	
    45. 

  45. 	 	 
    46. 

  46. Detailed Table Information	Table(tableName:dest1, dbName:default, owner:sdong, createTime:1297331254, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/data/users/sdong/www/open-source-hive1/build/ql/test/data/warehouse/dest1, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1297331254}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
    47. 

  47. PREHOOK: query: FROM src
    48. 

  48. INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 10
    49. 

  49. PREHOOK: type: QUERY
    50. 

  50. PREHOOK: Input: default@src
    51. 

  51. PREHOOK: Output: default@dest1
    52. 

  52. POSTHOOK: query: FROM src
    53. 

  53. INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 10
    54. 

  54. POSTHOOK: type: QUERY
    55. 

  55. POSTHOOK: Input: default@src
    56. 

  56. POSTHOOK: Output: default@dest1
    57. 

  57. POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    58. 

  58. POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    59. 

  59. PREHOOK: query: SELECT dest1.* FROM dest1
    60. 

  60. PREHOOK: type: QUERY
    61. 

  61. PREHOOK: Input: default@dest1
    62. 

  62. PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-47-38_871_2911208910534048188/-mr-10000
    63. 

  63. POSTHOOK: query: SELECT dest1.* FROM dest1
    64. 

  64. POSTHOOK: type: QUERY
    65. 

  65. POSTHOOK: Input: default@dest1
    66. 

  66. POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_01-47-38_871_2911208910534048188/-mr-10000
    67. 

  67. POSTHOOK: Lineage: dest1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    68. 

  68. POSTHOOK: Lineage: dest1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
    69. 

  69. 0	val_0
    70. 

  70. 4	val_4
    71. 

  71. 8	val_8
    72. 

  72. 0	val_0
    73. 

  73. 0	val_0
    74. 

  74. 5	val_5
    75. 

  75. 5	val_5
    76. 

  76. 2	val_2
    77. 

  77. 5	val_5
    78. 

  78. 9	val_9
    79. 

  79.