PageRenderTime 57ms CodeModel.GetById 20ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 66 lines | 62 code | 4 blank | 0 comment | 0 complexity | ab415f058624ae829d3c38bab9592157 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: CREATE TABLE rcfile_default_format (key STRING)
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: CREATE TABLE rcfile_default_format (key STRING)
    4. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@rcfile_default_format
    6. 

  6. PREHOOK: query: DESCRIBE EXTENDED rcfile_default_format
    7. 

  7. PREHOOK: type: DESCTABLE
    8. 

  8. POSTHOOK: query: DESCRIBE EXTENDED rcfile_default_format
    9. 

  9. POSTHOOK: type: DESCTABLE
    10. 

  10. key	string	from deserializer
    11. 

  11. 	 	 
    12. 

  12. Detailed Table Information	Table(tableName:rcfile_default_format, dbName:default, owner:heyongqiang, createTime:1290106787, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/rcfile_default_format, inputFormat:org.apache.hadoop.hive.ql.io.RCFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1290106787}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
    13. 

  13. PREHOOK: query: CREATE TABLE rcfile_default_format_ctas AS SELECT key,value FROM src
    14. 

  14. PREHOOK: type: CREATETABLE_AS_SELECT
    15. 

  15. PREHOOK: Input: default@src
    16. 

  16. POSTHOOK: query: CREATE TABLE rcfile_default_format_ctas AS SELECT key,value FROM src
    17. 

  17. POSTHOOK: type: CREATETABLE_AS_SELECT
    18. 

  18. POSTHOOK: Input: default@src
    19. 

  19. POSTHOOK: Output: default@rcfile_default_format_ctas
    20. 

  20. PREHOOK: query: DESCRIBE EXTENDED rcfile_default_format_ctas
    21. 

  21. PREHOOK: type: DESCTABLE
    22. 

  22. POSTHOOK: query: DESCRIBE EXTENDED rcfile_default_format_ctas
    23. 

  23. POSTHOOK: type: DESCTABLE
    24. 

  24. key	string	from deserializer
    25. 

  25. value	string	from deserializer
    26. 

  26. 	 	 
    27. 

  27. Detailed Table Information	Table(tableName:rcfile_default_format_ctas, dbName:default, owner:heyongqiang, createTime:1290106793, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/rcfile_default_format_ctas, inputFormat:org.apache.hadoop.hive.ql.io.RCFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.RCFileOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}), partitionKeys:[], parameters:{transient_lastDdlTime=1290106793}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
    28. 

  28. PREHOOK: query: CREATE TABLE rcfile_default_format_txtfile (key STRING) STORED AS TEXTFILE
    29. 

  29. PREHOOK: type: CREATETABLE
    30. 

  30. POSTHOOK: query: CREATE TABLE rcfile_default_format_txtfile (key STRING) STORED AS TEXTFILE
    31. 

  31. POSTHOOK: type: CREATETABLE
    32. 

  32. POSTHOOK: Output: default@rcfile_default_format_txtfile
    33. 

  33. PREHOOK: query: INSERT OVERWRITE TABLE rcfile_default_format_txtfile SELECT key from src
    34. 

  34. PREHOOK: type: QUERY
    35. 

  35. PREHOOK: Input: default@src
    36. 

  36. PREHOOK: Output: default@rcfile_default_format_txtfile
    37. 

  37. POSTHOOK: query: INSERT OVERWRITE TABLE rcfile_default_format_txtfile SELECT key from src
    38. 

  38. POSTHOOK: type: QUERY
    39. 

  39. POSTHOOK: Input: default@src
    40. 

  40. POSTHOOK: Output: default@rcfile_default_format_txtfile
    41. 

  41. POSTHOOK: Lineage: rcfile_default_format_txtfile.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    42. 

  42. PREHOOK: query: DESCRIBE EXTENDED rcfile_default_format_txtfile
    43. 

  43. PREHOOK: type: DESCTABLE
    44. 

  44. POSTHOOK: query: DESCRIBE EXTENDED rcfile_default_format_txtfile
    45. 

  45. POSTHOOK: type: DESCTABLE
    46. 

  46. POSTHOOK: Lineage: rcfile_default_format_txtfile.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    47. 

  47. key	string	
    48. 

  48. 	 	 
    49. 

  49. Detailed Table Information	Table(tableName:rcfile_default_format_txtfile, dbName:default, owner:heyongqiang, createTime:1290106794, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/rcfile_default_format_txtfile, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, 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:{numPartitions=0, numFiles=1, transient_lastDdlTime=1290106803, numRows=500, totalSize=1906}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
    50. 

  50. PREHOOK: query: CREATE TABLE textfile_default_format_ctas AS SELECT key,value FROM rcfile_default_format_ctas
    51. 

  51. PREHOOK: type: CREATETABLE_AS_SELECT
    52. 

  52. PREHOOK: Input: default@rcfile_default_format_ctas
    53. 

  53. POSTHOOK: query: CREATE TABLE textfile_default_format_ctas AS SELECT key,value FROM rcfile_default_format_ctas
    54. 

  54. POSTHOOK: type: CREATETABLE_AS_SELECT
    55. 

  55. POSTHOOK: Input: default@rcfile_default_format_ctas
    56. 

  56. POSTHOOK: Output: default@textfile_default_format_ctas
    57. 

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

  58. PREHOOK: query: DESCRIBE EXTENDED textfile_default_format_ctas
    59. 

  59. PREHOOK: type: DESCTABLE
    60. 

  60. POSTHOOK: query: DESCRIBE EXTENDED textfile_default_format_ctas
    61. 

  61. POSTHOOK: type: DESCTABLE
    62. 

  62. POSTHOOK: Lineage: rcfile_default_format_txtfile.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
    63. 

  63. key	string	
    64. 

  64. value	string	
    65. 

  65. 	 	 
    66. 

  66. Detailed Table Information	Table(tableName:textfile_default_format_ctas, dbName:default, owner:heyongqiang, createTime:1290106809, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:string, comment:null), FieldSchema(name:value, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/textfile_default_format_ctas, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, 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=1290106809}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
    67. 

  67.