PageRenderTime 40ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 0ms

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

#
text | 49 lines | 46 code | 3 blank | 0 comment | 0 complexity | 58a1ced88eed01af5ae1c9615ba3988d MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0 
    

  1. PREHOOK: query: -- a simple test to test sorted/clustered syntax
    2. 

  2. 

  3. CREATE TABLE INPUTDDL4(viewTime STRING, userid INT,
    4. 

  4.                        page_url STRING, referrer_url STRING, 
    5. 

  5.                        friends ARRAY<BIGINT>, properties MAP<STRING, STRING>,
    6. 

  6.                        ip STRING COMMENT 'IP Address of the User') 
    7. 

  7.     COMMENT 'This is the page view table' 
    8. 

  8.     PARTITIONED BY(ds STRING, country STRING) 
    9. 

  9.     CLUSTERED BY(userid) SORTED BY(viewTime) INTO 32 BUCKETS
    10. 

  10. PREHOOK: type: CREATETABLE
    11. 

  11. POSTHOOK: query: -- a simple test to test sorted/clustered syntax
    12. 

  12. 

  13. CREATE TABLE INPUTDDL4(viewTime STRING, userid INT,
    14. 

  14.                        page_url STRING, referrer_url STRING, 
    15. 

  15.                        friends ARRAY<BIGINT>, properties MAP<STRING, STRING>,
    16. 

  16.                        ip STRING COMMENT 'IP Address of the User') 
    17. 

  17.     COMMENT 'This is the page view table' 
    18. 

  18.     PARTITIONED BY(ds STRING, country STRING) 
    19. 

  19.     CLUSTERED BY(userid) SORTED BY(viewTime) INTO 32 BUCKETS
    20. 

  20. POSTHOOK: type: CREATETABLE
    21. 

  21. POSTHOOK: Output: default@INPUTDDL4
    22. 

  22. PREHOOK: query: DESCRIBE INPUTDDL4
    23. 

  23. PREHOOK: type: DESCTABLE
    24. 

  24. POSTHOOK: query: DESCRIBE INPUTDDL4
    25. 

  25. POSTHOOK: type: DESCTABLE
    26. 

  26. viewtime	string	
    27. 

  27. userid	int	
    28. 

  28. page_url	string	
    29. 

  29. referrer_url	string	
    30. 

  30. friends	array<bigint>	
    31. 

  31. properties	map<string,string>	
    32. 

  32. ip	string	IP Address of the User
    33. 

  33. ds	string	
    34. 

  34. country	string	
    35. 

  35. PREHOOK: query: DESCRIBE EXTENDED INPUTDDL4
    36. 

  36. PREHOOK: type: DESCTABLE
    37. 

  37. POSTHOOK: query: DESCRIBE EXTENDED INPUTDDL4
    38. 

  38. POSTHOOK: type: DESCTABLE
    39. 

  39. viewtime	string	
    40. 

  40. userid	int	
    41. 

  41. page_url	string	
    42. 

  42. referrer_url	string	
    43. 

  43. friends	array<bigint>	
    44. 

  44. properties	map<string,string>	
    45. 

  45. ip	string	IP Address of the User
    46. 

  46. ds	string	
    47. 

  47. country	string	
    48. 

  48. 	 	 
    49. 

  49. Detailed Table Information	Table(tableName:inputddl4, dbName:default, owner:thiruvel, createTime:1286798568, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:viewtime, type:string, comment:null), FieldSchema(name:userid, type:int, comment:null), FieldSchema(name:page_url, type:string, comment:null), FieldSchema(name:referrer_url, type:string, comment:null), FieldSchema(name:friends, type:array<bigint>, comment:null), FieldSchema(name:properties, type:map<string,string>, comment:null), FieldSchema(name:ip, type:string, comment:IP Address of the User), FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:country, type:string, comment:null)], location:pfile:/home/thiruvel/projects/hive/hive.unsecure/build/ql/test/data/warehouse/inputddl4, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:32, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[userid], sortCols:[Order(col:viewtime, order:1)], parameters:{}), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:country, type:string, comment:null)], parameters:{transient_lastDdlTime=1286798568, comment=This is the page view table}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
    50. 

  50.