PageRenderTime 45ms CodeModel.GetById 21ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 38 lines | 35 code | 3 blank | 0 comment | 0 complexity | 7fa1fd8bc072524083e08952e6e4fcc6 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: CREATE TABLE table_p1 (a STRING)
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: CREATE TABLE table_p1 (a STRING)
    4. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@table_p1
    6. 

  6. PREHOOK: query: DESC EXTENDED table_p1
    7. 

  7. PREHOOK: type: DESCTABLE
    8. 

  8. POSTHOOK: query: DESC EXTENDED table_p1
    9. 

  9. POSTHOOK: type: DESCTABLE
    10. 

  10. a	string	
    11. 

  11. 	 	 
    12. 

  12. Detailed Table Information	Table(tableName:table_p1, dbName:default, owner:heyongqiang, createTime:1290111690, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/table_p1, 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:{p1=v1, transient_lastDdlTime=1290111690, P2=v21=v22=v23}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
    13. 

  13. PREHOOK: query: CREATE TABLE table_p2 LIKE table_p1
    14. 

  14. PREHOOK: type: CREATETABLE
    15. 

  15. POSTHOOK: query: CREATE TABLE table_p2 LIKE table_p1
    16. 

  16. POSTHOOK: type: CREATETABLE
    17. 

  17. POSTHOOK: Output: default@table_p2
    18. 

  18. PREHOOK: query: DESC EXTENDED table_p2
    19. 

  19. PREHOOK: type: DESCTABLE
    20. 

  20. POSTHOOK: query: DESC EXTENDED table_p2
    21. 

  21. POSTHOOK: type: DESCTABLE
    22. 

  22. a	string	
    23. 

  23. 	 	 
    24. 

  24. Detailed Table Information	Table(tableName:table_p2, dbName:default, owner:heyongqiang, createTime:1290111690, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/table_p2, 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=1290111690}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
    25. 

  25. PREHOOK: query: CREATE TABLE table_p3 AS SELECT * FROM table_p1
    26. 

  26. PREHOOK: type: CREATETABLE_AS_SELECT
    27. 

  27. PREHOOK: Input: default@table_p1
    28. 

  28. POSTHOOK: query: CREATE TABLE table_p3 AS SELECT * FROM table_p1
    29. 

  29. POSTHOOK: type: CREATETABLE_AS_SELECT
    30. 

  30. POSTHOOK: Input: default@table_p1
    31. 

  31. POSTHOOK: Output: default@table_p3
    32. 

  32. PREHOOK: query: DESC EXTENDED table_p3
    33. 

  33. PREHOOK: type: DESCTABLE
    34. 

  34. POSTHOOK: query: DESC EXTENDED table_p3
    35. 

  35. POSTHOOK: type: DESCTABLE
    36. 

  36. a	string	
    37. 

  37. 	 	 
    38. 

  38. Detailed Table Information	Table(tableName:table_p3, dbName:default, owner:heyongqiang, createTime:1290111696, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:a, type:string, comment:null)], location:pfile:/Users/heyongqiang/Documents/workspace/Hive-2/build/ql/test/data/warehouse/table_p3, 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:{p3=v3, transient_lastDdlTime=1290111696}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
    39. 

  39.