Saving all output to "!!{outputDirectory}!!/inputddl8.q.raw". Enter "record" with no arguments to stop it. >>> !run !!{qFileDirectory}!!/inputddl8.q >>> >>> CREATE TABLE INPUTDDL8 COMMENT 'This is a thrift based table' PARTITIONED BY(ds STRING, country STRING) CLUSTERED BY(aint) SORTED BY(lint) INTO 32 BUCKETS ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.thrift.ThriftDeserializer' WITH SERDEPROPERTIES ('serialization.class' = 'org.apache.hadoop.hive.serde2.thrift.test.Complex', 'serialization.format' = 'com.facebook.thrift.protocol.TBinaryProtocol') STORED AS SEQUENCEFILE; No rows affected >>> DESCRIBE EXTENDED INPUTDDL8; 'col_name','data_type','comment' 'aint','int','from deserializer' 'astring','string','from deserializer' 'lint','array','from deserializer' 'lstring','array','from deserializer' 'lintstring','array>','from deserializer' 'mstringstring','map','from deserializer' 'ds','string','' 'country','string','' '','','' 'Detailed Table Information','Table(tableName:inputddl8, dbName:inputddl8, owner:!!{user.name}!!, createTime:!!UNIXTIME!!, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[], location:!!{hive.metastore.warehouse.dir}!!/inputddl8.db/inputddl8, inputFormat:org.apache.hadoop.mapred.SequenceFileInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat, compressed:false, numBuckets:32, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.thrift.ThriftDeserializer, parameters:{serialization.class=org.apache.hadoop.hive.serde2.thrift.test.Complex, serialization.format=com.facebook.thrift.protocol.TBinaryProtocol}), bucketCols:[aint], sortCols:[Order(col:lint, order:1)], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{})), partitionKeys:[FieldSchema(name:ds, type:string, comment:null), FieldSchema(name:country, type:string, comment:null)], parameters:{transient_lastDdlTime=!!UNIXTIME!!, comment=This is a thrift based table}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)','' 10 rows selected >>> >>> !record