hbase-handler/src/test/results/positive/hbase_timestamp.q.out - hive - Git at Google

 PREHOOK: query: DROP TABLE hbase_table
 PREHOOK: type: DROPTABLE
 POSTHOOK: query: DROP TABLE hbase_table
 POSTHOOK: type: DROPTABLE
 PREHOOK: query: CREATE EXTERNAL TABLE hbase_table (key string, value string, `time` timestamp)
   STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
   WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:string,:timestamp")
   TBLPROPERTIES ("external.table.purge" = "true")
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
 PREHOOK: Output: default@hbase_table
 POSTHOOK: query: CREATE EXTERNAL TABLE hbase_table (key string, value string, `time` timestamp)
   STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
   WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:string,:timestamp")
   TBLPROPERTIES ("external.table.purge" = "true")
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@hbase_table
 PREHOOK: query: DESC extended hbase_table
 PREHOOK: type: DESCTABLE
 PREHOOK: Input: default@hbase_table
 POSTHOOK: query: DESC extended hbase_table
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: default@hbase_table
 key                 	string
 value               	string
 time                	timestamp

 #### A masked pattern was here ####
 PREHOOK: query: FROM src INSERT OVERWRITE TABLE hbase_table SELECT key, value, "2012-02-23 10:14:52" WHERE (key % 17) = 0
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@hbase_table
 POSTHOOK: query: FROM src INSERT OVERWRITE TABLE hbase_table SELECT key, value, "2012-02-23 10:14:52" WHERE (key % 17) = 0
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@hbase_table
 PREHOOK: query: SELECT * FROM hbase_table
 PREHOOK: type: QUERY
 PREHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 POSTHOOK: query: SELECT * FROM hbase_table
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 0	val_0	2012-02-23 10:14:52
 119	val_119	2012-02-23 10:14:52
 136	val_136	2012-02-23 10:14:52
 153	val_153	2012-02-23 10:14:52
 17	val_17	2012-02-23 10:14:52
 170	val_170	2012-02-23 10:14:52
 187	val_187	2012-02-23 10:14:52
 221	val_221	2012-02-23 10:14:52
 238	val_238	2012-02-23 10:14:52
 255	val_255	2012-02-23 10:14:52
 272	val_272	2012-02-23 10:14:52
 289	val_289	2012-02-23 10:14:52
 306	val_306	2012-02-23 10:14:52
 323	val_323	2012-02-23 10:14:52
 34	val_34	2012-02-23 10:14:52
 374	val_374	2012-02-23 10:14:52
 459	val_459	2012-02-23 10:14:52
 493	val_493	2012-02-23 10:14:52
 51	val_51	2012-02-23 10:14:52
 85	val_85	2012-02-23 10:14:52
 PREHOOK: query: DROP TABLE hbase_table
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@hbase_table
 PREHOOK: Output: default@hbase_table
 POSTHOOK: query: DROP TABLE hbase_table
 POSTHOOK: type: DROPTABLE
 POSTHOOK: Input: default@hbase_table
 POSTHOOK: Output: default@hbase_table
 PREHOOK: query: CREATE EXTERNAL TABLE hbase_table (key string, value string, `time` bigint)
   STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
   WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:string,:timestamp")
   TBLPROPERTIES ("external.table.purge" = "true")
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
 PREHOOK: Output: default@hbase_table
 POSTHOOK: query: CREATE EXTERNAL TABLE hbase_table (key string, value string, `time` bigint)
   STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
   WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:string,:timestamp")
   TBLPROPERTIES ("external.table.purge" = "true")
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@hbase_table
 PREHOOK: query: FROM src INSERT OVERWRITE TABLE hbase_table SELECT key, value, 1329959754000 WHERE (key % 17) = 0
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@hbase_table
 POSTHOOK: query: FROM src INSERT OVERWRITE TABLE hbase_table SELECT key, value, 1329959754000 WHERE (key % 17) = 0
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@hbase_table
 PREHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table
 PREHOOK: type: QUERY
 PREHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 POSTHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 0	val_0	2012-02-23 01:15:54
 119	val_119	2012-02-23 01:15:54
 136	val_136	2012-02-23 01:15:54
 153	val_153	2012-02-23 01:15:54
 17	val_17	2012-02-23 01:15:54
 170	val_170	2012-02-23 01:15:54
 187	val_187	2012-02-23 01:15:54
 221	val_221	2012-02-23 01:15:54
 238	val_238	2012-02-23 01:15:54
 255	val_255	2012-02-23 01:15:54
 272	val_272	2012-02-23 01:15:54
 289	val_289	2012-02-23 01:15:54
 306	val_306	2012-02-23 01:15:54
 323	val_323	2012-02-23 01:15:54
 34	val_34	2012-02-23 01:15:54
 374	val_374	2012-02-23 01:15:54
 459	val_459	2012-02-23 01:15:54
 493	val_493	2012-02-23 01:15:54
 51	val_51	2012-02-23 01:15:54
 85	val_85	2012-02-23 01:15:54
 PREHOOK: query: DROP TABLE hbase_table
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@hbase_table
 PREHOOK: Output: default@hbase_table
 POSTHOOK: query: DROP TABLE hbase_table
 POSTHOOK: type: DROPTABLE
 POSTHOOK: Input: default@hbase_table
 POSTHOOK: Output: default@hbase_table
 PREHOOK: query: CREATE EXTERNAL TABLE hbase_table (key string, value string, `time` bigint)
   STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
   WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:string,:timestamp")
   TBLPROPERTIES ("external.table.purge" = "true")
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
 PREHOOK: Output: default@hbase_table
 POSTHOOK: query: CREATE EXTERNAL TABLE hbase_table (key string, value string, `time` bigint)
   STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
   WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:string,:timestamp")
   TBLPROPERTIES ("external.table.purge" = "true")
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@hbase_table
 PREHOOK: query: insert overwrite table hbase_table select key,value,ts FROM
 (
   select key, value, 100000000000 as ts from src WHERE (key % 33) = 0
   UNION ALL
   select key, value, 200000000000 as ts from src WHERE (key % 37) = 0
 ) T
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@hbase_table
 POSTHOOK: query: insert overwrite table hbase_table select key,value,ts FROM
 (
   select key, value, 100000000000 as ts from src WHERE (key % 33) = 0
   UNION ALL
   select key, value, 200000000000 as ts from src WHERE (key % 37) = 0
 ) T
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@hbase_table
 PREHOOK: query: explain
 SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` < 200000000000
 PREHOOK: type: QUERY
 PREHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 POSTHOOK: query: explain
 SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` < 200000000000
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-0 depends on stages: Stage-1

 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
       Map Operator Tree:
           TableScan
             alias: hbase_table
             Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (((UDFToDouble(key) > 100.0D) and (UDFToDouble(key) < 400.0D)) and (time < 200000000000L)) (type: boolean)
               Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string), CAST( time AS TIMESTAMP) (type: timestamp)
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
                   Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
       Execution mode: vectorized

   Stage: Stage-0
     Fetch Operator
       limit: -1
       Processor Tree:
         ListSink

 PREHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` < 200000000000
 PREHOOK: type: QUERY
 PREHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 POSTHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` < 200000000000
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 165	val_165	1973-03-03 09:46:40
 396	val_396	1973-03-03 09:46:40
 PREHOOK: query: explain
 SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` > 100000000000
 PREHOOK: type: QUERY
 PREHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 POSTHOOK: query: explain
 SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` > 100000000000
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-0 depends on stages: Stage-1

 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
       Map Operator Tree:
           TableScan
             alias: hbase_table
             Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (((UDFToDouble(key) > 100.0D) and (UDFToDouble(key) < 400.0D)) and (time > 100000000000L)) (type: boolean)
               Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string), CAST( time AS TIMESTAMP) (type: timestamp)
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
                   Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
       Execution mode: vectorized

   Stage: Stage-0
     Fetch Operator
       limit: -1
       Processor Tree:
         ListSink

 PREHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` > 100000000000
 PREHOOK: type: QUERY
 PREHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 POSTHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` > 100000000000
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 111	val_111	1976-05-03 19:33:20
 222	val_222	1976-05-03 19:33:20
 296	val_296	1976-05-03 19:33:20
 333	val_333	1976-05-03 19:33:20
 PREHOOK: query: explain
 SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` <= 100000000000
 PREHOOK: type: QUERY
 PREHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 POSTHOOK: query: explain
 SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` <= 100000000000
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-0 depends on stages: Stage-1

 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
       Map Operator Tree:
           TableScan
             alias: hbase_table
             Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (((UDFToDouble(key) > 100.0D) and (UDFToDouble(key) < 400.0D)) and (time <= 100000000000L)) (type: boolean)
               Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string), CAST( time AS TIMESTAMP) (type: timestamp)
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
                   Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
       Execution mode: vectorized

   Stage: Stage-0
     Fetch Operator
       limit: -1
       Processor Tree:
         ListSink

 PREHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` <= 100000000000
 PREHOOK: type: QUERY
 PREHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 POSTHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` <= 100000000000
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 165	val_165	1973-03-03 09:46:40
 396	val_396	1973-03-03 09:46:40
 PREHOOK: query: explain
 SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` >= 200000000000
 PREHOOK: type: QUERY
 PREHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 POSTHOOK: query: explain
 SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` >= 200000000000
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-0 depends on stages: Stage-1

 STAGE PLANS:
   Stage: Stage-1
     Map Reduce
       Map Operator Tree:
           TableScan
             alias: hbase_table
             Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
             Filter Operator
               predicate: (((UDFToDouble(key) > 100.0D) and (UDFToDouble(key) < 400.0D)) and (time >= 200000000000L)) (type: boolean)
               Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
               Select Operator
                 expressions: key (type: string), value (type: string), CAST( time AS TIMESTAMP) (type: timestamp)
                 outputColumnNames: _col0, _col1, _col2
                 Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
                 File Output Operator
                   compressed: false
                   Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
                   table:
                       input format: org.apache.hadoop.mapred.SequenceFileInputFormat
                       output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
       Execution mode: vectorized

   Stage: Stage-0
     Fetch Operator
       limit: -1
       Processor Tree:
         ListSink

 PREHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` >= 200000000000
 PREHOOK: type: QUERY
 PREHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 POSTHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` >= 200000000000
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 111	val_111	1976-05-03 19:33:20
 222	val_222	1976-05-03 19:33:20
 296	val_296	1976-05-03 19:33:20
 333	val_333	1976-05-03 19:33:20
 PREHOOK: query: DROP TABLE hbase_table
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@hbase_table
 PREHOOK: Output: default@hbase_table
 POSTHOOK: query: DROP TABLE hbase_table
 POSTHOOK: type: DROPTABLE
 POSTHOOK: Input: default@hbase_table
 POSTHOOK: Output: default@hbase_table
 PREHOOK: query: CREATE EXTERNAL TABLE hbase_table(key string, value map<string, string>, `time` timestamp)
 STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
 WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:,:timestamp")
 TBLPROPERTIES ("external.table.purge" = "true")
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:default
 PREHOOK: Output: default@hbase_table
 POSTHOOK: query: CREATE EXTERNAL TABLE hbase_table(key string, value map<string, string>, `time` timestamp)
 STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
 WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:,:timestamp")
 TBLPROPERTIES ("external.table.purge" = "true")
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:default
 POSTHOOK: Output: default@hbase_table
 PREHOOK: query: FROM src INSERT OVERWRITE TABLE hbase_table SELECT key, MAP("name", CONCAT(value, " Jr")), "2012-02-23 10:14:52" WHERE (key % 17) = 0
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@hbase_table
 POSTHOOK: query: FROM src INSERT OVERWRITE TABLE hbase_table SELECT key, MAP("name", CONCAT(value, " Jr")), "2012-02-23 10:14:52" WHERE (key % 17) = 0
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@hbase_table
 PREHOOK: query: FROM src INSERT INTO TABLE hbase_table SELECT key, MAP("age", '40'), "2015-12-12 12:12:12" WHERE (key % 17) = 0
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@hbase_table
 POSTHOOK: query: FROM src INSERT INTO TABLE hbase_table SELECT key, MAP("age", '40'), "2015-12-12 12:12:12" WHERE (key % 17) = 0
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@hbase_table
 PREHOOK: query: FROM src INSERT INTO TABLE hbase_table SELECT key, MAP("name", value), "2000-01-01 01:01:01" WHERE (key % 17) = 0
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
 PREHOOK: Output: default@hbase_table
 POSTHOOK: query: FROM src INSERT INTO TABLE hbase_table SELECT key, MAP("name", value), "2000-01-01 01:01:01" WHERE (key % 17) = 0
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@hbase_table
 PREHOOK: query: SELECT * FROM hbase_table
 PREHOOK: type: QUERY
 PREHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 POSTHOOK: query: SELECT * FROM hbase_table
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@hbase_table
 #### A masked pattern was here ####
 0	{"age":"40","name":"val_0 Jr"}	2015-12-12 12:12:12
 119	{"age":"40","name":"val_119 Jr"}	2015-12-12 12:12:12
 136	{"age":"40","name":"val_136 Jr"}	2015-12-12 12:12:12
 153	{"age":"40","name":"val_153 Jr"}	2015-12-12 12:12:12
 17	{"age":"40","name":"val_17 Jr"}	2015-12-12 12:12:12
 170	{"age":"40","name":"val_170 Jr"}	2015-12-12 12:12:12
 187	{"age":"40","name":"val_187 Jr"}	2015-12-12 12:12:12
 221	{"age":"40","name":"val_221 Jr"}	2015-12-12 12:12:12
 238	{"age":"40","name":"val_238 Jr"}	2015-12-12 12:12:12
 255	{"age":"40","name":"val_255 Jr"}	2015-12-12 12:12:12
 272	{"age":"40","name":"val_272 Jr"}	2015-12-12 12:12:12
 289	{"age":"40","name":"val_289 Jr"}	2015-12-12 12:12:12
 306	{"age":"40","name":"val_306 Jr"}	2015-12-12 12:12:12
 323	{"age":"40","name":"val_323 Jr"}	2015-12-12 12:12:12
 34	{"age":"40","name":"val_34 Jr"}	2015-12-12 12:12:12
 374	{"age":"40","name":"val_374 Jr"}	2015-12-12 12:12:12
 459	{"age":"40","name":"val_459 Jr"}	2015-12-12 12:12:12
 493	{"age":"40","name":"val_493 Jr"}	2015-12-12 12:12:12
 51	{"age":"40","name":"val_51 Jr"}	2015-12-12 12:12:12
 85	{"age":"40","name":"val_85 Jr"}	2015-12-12 12:12:12
	PREHOOK: query: DROP TABLE hbase_table
	PREHOOK: type: DROPTABLE
	POSTHOOK: query: DROP TABLE hbase_table
	POSTHOOK: type: DROPTABLE
	PREHOOK: query: CREATE EXTERNAL TABLE hbase_table (key string, value string, `time` timestamp)
	STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
	WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:string,:timestamp")
	TBLPROPERTIES ("external.table.purge" = "true")
	PREHOOK: type: CREATETABLE
	PREHOOK: Output: database:default
	PREHOOK: Output: default@hbase_table
	POSTHOOK: query: CREATE EXTERNAL TABLE hbase_table (key string, value string, `time` timestamp)
	STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
	WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:string,:timestamp")
	TBLPROPERTIES ("external.table.purge" = "true")
	POSTHOOK: type: CREATETABLE
	POSTHOOK: Output: database:default
	POSTHOOK: Output: default@hbase_table
	PREHOOK: query: DESC extended hbase_table
	PREHOOK: type: DESCTABLE
	PREHOOK: Input: default@hbase_table
	POSTHOOK: query: DESC extended hbase_table
	POSTHOOK: type: DESCTABLE
	POSTHOOK: Input: default@hbase_table
	key string
	value string
	time timestamp

	#### A masked pattern was here ####
	PREHOOK: query: FROM src INSERT OVERWRITE TABLE hbase_table SELECT key, value, "2012-02-23 10:14:52" WHERE (key % 17) = 0
	PREHOOK: type: QUERY
	PREHOOK: Input: default@src
	PREHOOK: Output: default@hbase_table
	POSTHOOK: query: FROM src INSERT OVERWRITE TABLE hbase_table SELECT key, value, "2012-02-23 10:14:52" WHERE (key % 17) = 0
	POSTHOOK: type: QUERY
	POSTHOOK: Input: default@src
	POSTHOOK: Output: default@hbase_table
	PREHOOK: query: SELECT * FROM hbase_table
	PREHOOK: type: QUERY
	PREHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	POSTHOOK: query: SELECT * FROM hbase_table
	POSTHOOK: type: QUERY
	POSTHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	0 val_0 2012-02-23 10:14:52
	119 val_119 2012-02-23 10:14:52
	136 val_136 2012-02-23 10:14:52
	153 val_153 2012-02-23 10:14:52
	17 val_17 2012-02-23 10:14:52
	170 val_170 2012-02-23 10:14:52
	187 val_187 2012-02-23 10:14:52
	221 val_221 2012-02-23 10:14:52
	238 val_238 2012-02-23 10:14:52
	255 val_255 2012-02-23 10:14:52
	272 val_272 2012-02-23 10:14:52
	289 val_289 2012-02-23 10:14:52
	306 val_306 2012-02-23 10:14:52
	323 val_323 2012-02-23 10:14:52
	34 val_34 2012-02-23 10:14:52
	374 val_374 2012-02-23 10:14:52
	459 val_459 2012-02-23 10:14:52
	493 val_493 2012-02-23 10:14:52
	51 val_51 2012-02-23 10:14:52
	85 val_85 2012-02-23 10:14:52
	PREHOOK: query: DROP TABLE hbase_table
	PREHOOK: type: DROPTABLE
	PREHOOK: Input: default@hbase_table
	PREHOOK: Output: default@hbase_table
	POSTHOOK: query: DROP TABLE hbase_table
	POSTHOOK: type: DROPTABLE
	POSTHOOK: Input: default@hbase_table
	POSTHOOK: Output: default@hbase_table
	PREHOOK: query: CREATE EXTERNAL TABLE hbase_table (key string, value string, `time` bigint)
	STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
	WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:string,:timestamp")
	TBLPROPERTIES ("external.table.purge" = "true")
	PREHOOK: type: CREATETABLE
	PREHOOK: Output: database:default
	PREHOOK: Output: default@hbase_table
	POSTHOOK: query: CREATE EXTERNAL TABLE hbase_table (key string, value string, `time` bigint)
	STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
	WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:string,:timestamp")
	TBLPROPERTIES ("external.table.purge" = "true")
	POSTHOOK: type: CREATETABLE
	POSTHOOK: Output: database:default
	POSTHOOK: Output: default@hbase_table
	PREHOOK: query: FROM src INSERT OVERWRITE TABLE hbase_table SELECT key, value, 1329959754000 WHERE (key % 17) = 0
	PREHOOK: type: QUERY
	PREHOOK: Input: default@src
	PREHOOK: Output: default@hbase_table
	POSTHOOK: query: FROM src INSERT OVERWRITE TABLE hbase_table SELECT key, value, 1329959754000 WHERE (key % 17) = 0
	POSTHOOK: type: QUERY
	POSTHOOK: Input: default@src
	POSTHOOK: Output: default@hbase_table
	PREHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table
	PREHOOK: type: QUERY
	PREHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	POSTHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table
	POSTHOOK: type: QUERY
	POSTHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	0 val_0 2012-02-23 01:15:54
	119 val_119 2012-02-23 01:15:54
	136 val_136 2012-02-23 01:15:54
	153 val_153 2012-02-23 01:15:54
	17 val_17 2012-02-23 01:15:54
	170 val_170 2012-02-23 01:15:54
	187 val_187 2012-02-23 01:15:54
	221 val_221 2012-02-23 01:15:54
	238 val_238 2012-02-23 01:15:54
	255 val_255 2012-02-23 01:15:54
	272 val_272 2012-02-23 01:15:54
	289 val_289 2012-02-23 01:15:54
	306 val_306 2012-02-23 01:15:54
	323 val_323 2012-02-23 01:15:54
	34 val_34 2012-02-23 01:15:54
	374 val_374 2012-02-23 01:15:54
	459 val_459 2012-02-23 01:15:54
	493 val_493 2012-02-23 01:15:54
	51 val_51 2012-02-23 01:15:54
	85 val_85 2012-02-23 01:15:54
	PREHOOK: query: DROP TABLE hbase_table
	PREHOOK: type: DROPTABLE
	PREHOOK: Input: default@hbase_table
	PREHOOK: Output: default@hbase_table
	POSTHOOK: query: DROP TABLE hbase_table
	POSTHOOK: type: DROPTABLE
	POSTHOOK: Input: default@hbase_table
	POSTHOOK: Output: default@hbase_table
	PREHOOK: query: CREATE EXTERNAL TABLE hbase_table (key string, value string, `time` bigint)
	STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
	WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:string,:timestamp")
	TBLPROPERTIES ("external.table.purge" = "true")
	PREHOOK: type: CREATETABLE
	PREHOOK: Output: database:default
	PREHOOK: Output: default@hbase_table
	POSTHOOK: query: CREATE EXTERNAL TABLE hbase_table (key string, value string, `time` bigint)
	STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
	WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:string,:timestamp")
	TBLPROPERTIES ("external.table.purge" = "true")
	POSTHOOK: type: CREATETABLE
	POSTHOOK: Output: database:default
	POSTHOOK: Output: default@hbase_table
	PREHOOK: query: insert overwrite table hbase_table select key,value,ts FROM
	(
	select key, value, 100000000000 as ts from src WHERE (key % 33) = 0
	UNION ALL
	select key, value, 200000000000 as ts from src WHERE (key % 37) = 0
	) T
	PREHOOK: type: QUERY
	PREHOOK: Input: default@src
	PREHOOK: Output: default@hbase_table
	POSTHOOK: query: insert overwrite table hbase_table select key,value,ts FROM
	(
	select key, value, 100000000000 as ts from src WHERE (key % 33) = 0
	UNION ALL
	select key, value, 200000000000 as ts from src WHERE (key % 37) = 0
	) T
	POSTHOOK: type: QUERY
	POSTHOOK: Input: default@src
	POSTHOOK: Output: default@hbase_table
	PREHOOK: query: explain
	SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` < 200000000000
	PREHOOK: type: QUERY
	PREHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	POSTHOOK: query: explain
	SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` < 200000000000
	POSTHOOK: type: QUERY
	POSTHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	STAGE DEPENDENCIES:
	Stage-1 is a root stage
	Stage-0 depends on stages: Stage-1

	STAGE PLANS:
	Stage: Stage-1
	Map Reduce
	Map Operator Tree:
	TableScan
	alias: hbase_table
	Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
	Filter Operator
	predicate: (((UDFToDouble(key) > 100.0D) and (UDFToDouble(key) < 400.0D)) and (time < 200000000000L)) (type: boolean)
	Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
	Select Operator
	expressions: key (type: string), value (type: string), CAST( time AS TIMESTAMP) (type: timestamp)
	outputColumnNames: _col0, _col1, _col2
	Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
	File Output Operator
	compressed: false
	Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
	table:
	input format: org.apache.hadoop.mapred.SequenceFileInputFormat
	output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
	serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
	Execution mode: vectorized

	Stage: Stage-0
	Fetch Operator
	limit: -1
	Processor Tree:
	ListSink

	PREHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` < 200000000000
	PREHOOK: type: QUERY
	PREHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	POSTHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` < 200000000000
	POSTHOOK: type: QUERY
	POSTHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	165 val_165 1973-03-03 09:46:40
	396 val_396 1973-03-03 09:46:40
	PREHOOK: query: explain
	SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` > 100000000000
	PREHOOK: type: QUERY
	PREHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	POSTHOOK: query: explain
	SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` > 100000000000
	POSTHOOK: type: QUERY
	POSTHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	STAGE DEPENDENCIES:
	Stage-1 is a root stage
	Stage-0 depends on stages: Stage-1

	STAGE PLANS:
	Stage: Stage-1
	Map Reduce
	Map Operator Tree:
	TableScan
	alias: hbase_table
	Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
	Filter Operator
	predicate: (((UDFToDouble(key) > 100.0D) and (UDFToDouble(key) < 400.0D)) and (time > 100000000000L)) (type: boolean)
	Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
	Select Operator
	expressions: key (type: string), value (type: string), CAST( time AS TIMESTAMP) (type: timestamp)
	outputColumnNames: _col0, _col1, _col2
	Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
	File Output Operator
	compressed: false
	Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
	table:
	input format: org.apache.hadoop.mapred.SequenceFileInputFormat
	output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
	serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
	Execution mode: vectorized

	Stage: Stage-0
	Fetch Operator
	limit: -1
	Processor Tree:
	ListSink

	PREHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` > 100000000000
	PREHOOK: type: QUERY
	PREHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	POSTHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` > 100000000000
	POSTHOOK: type: QUERY
	POSTHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	111 val_111 1976-05-03 19:33:20
	222 val_222 1976-05-03 19:33:20
	296 val_296 1976-05-03 19:33:20
	333 val_333 1976-05-03 19:33:20
	PREHOOK: query: explain
	SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` <= 100000000000
	PREHOOK: type: QUERY
	PREHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	POSTHOOK: query: explain
	SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` <= 100000000000
	POSTHOOK: type: QUERY
	POSTHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	STAGE DEPENDENCIES:
	Stage-1 is a root stage
	Stage-0 depends on stages: Stage-1

	STAGE PLANS:
	Stage: Stage-1
	Map Reduce
	Map Operator Tree:
	TableScan
	alias: hbase_table
	Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
	Filter Operator
	predicate: (((UDFToDouble(key) > 100.0D) and (UDFToDouble(key) < 400.0D)) and (time <= 100000000000L)) (type: boolean)
	Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
	Select Operator
	expressions: key (type: string), value (type: string), CAST( time AS TIMESTAMP) (type: timestamp)
	outputColumnNames: _col0, _col1, _col2
	Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
	File Output Operator
	compressed: false
	Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
	table:
	input format: org.apache.hadoop.mapred.SequenceFileInputFormat
	output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
	serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
	Execution mode: vectorized

	Stage: Stage-0
	Fetch Operator
	limit: -1
	Processor Tree:
	ListSink

	PREHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` <= 100000000000
	PREHOOK: type: QUERY
	PREHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	POSTHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` <= 100000000000
	POSTHOOK: type: QUERY
	POSTHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	165 val_165 1973-03-03 09:46:40
	396 val_396 1973-03-03 09:46:40
	PREHOOK: query: explain
	SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` >= 200000000000
	PREHOOK: type: QUERY
	PREHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	POSTHOOK: query: explain
	SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` >= 200000000000
	POSTHOOK: type: QUERY
	POSTHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	STAGE DEPENDENCIES:
	Stage-1 is a root stage
	Stage-0 depends on stages: Stage-1

	STAGE PLANS:
	Stage: Stage-1
	Map Reduce
	Map Operator Tree:
	TableScan
	alias: hbase_table
	Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
	Filter Operator
	predicate: (((UDFToDouble(key) > 100.0D) and (UDFToDouble(key) < 400.0D)) and (time >= 200000000000L)) (type: boolean)
	Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
	Select Operator
	expressions: key (type: string), value (type: string), CAST( time AS TIMESTAMP) (type: timestamp)
	outputColumnNames: _col0, _col1, _col2
	Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
	File Output Operator
	compressed: false
	Statistics: Num rows: 1 Data size: 376 Basic stats: COMPLETE Column stats: NONE
	table:
	input format: org.apache.hadoop.mapred.SequenceFileInputFormat
	output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
	serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
	Execution mode: vectorized

	Stage: Stage-0
	Fetch Operator
	limit: -1
	Processor Tree:
	ListSink

	PREHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` >= 200000000000
	PREHOOK: type: QUERY
	PREHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	POSTHOOK: query: SELECT key, value, cast(`time` as timestamp) FROM hbase_table WHERE key > 100 AND key < 400 AND `time` >= 200000000000
	POSTHOOK: type: QUERY
	POSTHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	111 val_111 1976-05-03 19:33:20
	222 val_222 1976-05-03 19:33:20
	296 val_296 1976-05-03 19:33:20
	333 val_333 1976-05-03 19:33:20
	PREHOOK: query: DROP TABLE hbase_table
	PREHOOK: type: DROPTABLE
	PREHOOK: Input: default@hbase_table
	PREHOOK: Output: default@hbase_table
	POSTHOOK: query: DROP TABLE hbase_table
	POSTHOOK: type: DROPTABLE
	POSTHOOK: Input: default@hbase_table
	POSTHOOK: Output: default@hbase_table
	PREHOOK: query: CREATE EXTERNAL TABLE hbase_table(key string, value map<string, string>, `time` timestamp)
	STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
	WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:,:timestamp")
	TBLPROPERTIES ("external.table.purge" = "true")
	PREHOOK: type: CREATETABLE
	PREHOOK: Output: database:default
	PREHOOK: Output: default@hbase_table
	POSTHOOK: query: CREATE EXTERNAL TABLE hbase_table(key string, value map<string, string>, `time` timestamp)
	STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
	WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:,:timestamp")
	TBLPROPERTIES ("external.table.purge" = "true")
	POSTHOOK: type: CREATETABLE
	POSTHOOK: Output: database:default
	POSTHOOK: Output: default@hbase_table
	PREHOOK: query: FROM src INSERT OVERWRITE TABLE hbase_table SELECT key, MAP("name", CONCAT(value, " Jr")), "2012-02-23 10:14:52" WHERE (key % 17) = 0
	PREHOOK: type: QUERY
	PREHOOK: Input: default@src
	PREHOOK: Output: default@hbase_table
	POSTHOOK: query: FROM src INSERT OVERWRITE TABLE hbase_table SELECT key, MAP("name", CONCAT(value, " Jr")), "2012-02-23 10:14:52" WHERE (key % 17) = 0
	POSTHOOK: type: QUERY
	POSTHOOK: Input: default@src
	POSTHOOK: Output: default@hbase_table
	PREHOOK: query: FROM src INSERT INTO TABLE hbase_table SELECT key, MAP("age", '40'), "2015-12-12 12:12:12" WHERE (key % 17) = 0
	PREHOOK: type: QUERY
	PREHOOK: Input: default@src
	PREHOOK: Output: default@hbase_table
	POSTHOOK: query: FROM src INSERT INTO TABLE hbase_table SELECT key, MAP("age", '40'), "2015-12-12 12:12:12" WHERE (key % 17) = 0
	POSTHOOK: type: QUERY
	POSTHOOK: Input: default@src
	POSTHOOK: Output: default@hbase_table
	PREHOOK: query: FROM src INSERT INTO TABLE hbase_table SELECT key, MAP("name", value), "2000-01-01 01:01:01" WHERE (key % 17) = 0
	PREHOOK: type: QUERY
	PREHOOK: Input: default@src
	PREHOOK: Output: default@hbase_table
	POSTHOOK: query: FROM src INSERT INTO TABLE hbase_table SELECT key, MAP("name", value), "2000-01-01 01:01:01" WHERE (key % 17) = 0
	POSTHOOK: type: QUERY
	POSTHOOK: Input: default@src
	POSTHOOK: Output: default@hbase_table
	PREHOOK: query: SELECT * FROM hbase_table
	PREHOOK: type: QUERY
	PREHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	POSTHOOK: query: SELECT * FROM hbase_table
	POSTHOOK: type: QUERY
	POSTHOOK: Input: default@hbase_table
	#### A masked pattern was here ####
	0 {"age":"40","name":"val_0 Jr"} 2015-12-12 12:12:12
	119 {"age":"40","name":"val_119 Jr"} 2015-12-12 12:12:12
	136 {"age":"40","name":"val_136 Jr"} 2015-12-12 12:12:12
	153 {"age":"40","name":"val_153 Jr"} 2015-12-12 12:12:12
	17 {"age":"40","name":"val_17 Jr"} 2015-12-12 12:12:12
	170 {"age":"40","name":"val_170 Jr"} 2015-12-12 12:12:12
	187 {"age":"40","name":"val_187 Jr"} 2015-12-12 12:12:12
	221 {"age":"40","name":"val_221 Jr"} 2015-12-12 12:12:12
	238 {"age":"40","name":"val_238 Jr"} 2015-12-12 12:12:12
	255 {"age":"40","name":"val_255 Jr"} 2015-12-12 12:12:12
	272 {"age":"40","name":"val_272 Jr"} 2015-12-12 12:12:12
	289 {"age":"40","name":"val_289 Jr"} 2015-12-12 12:12:12
	306 {"age":"40","name":"val_306 Jr"} 2015-12-12 12:12:12
	323 {"age":"40","name":"val_323 Jr"} 2015-12-12 12:12:12
	34 {"age":"40","name":"val_34 Jr"} 2015-12-12 12:12:12
	374 {"age":"40","name":"val_374 Jr"} 2015-12-12 12:12:12
	459 {"age":"40","name":"val_459 Jr"} 2015-12-12 12:12:12
	493 {"age":"40","name":"val_493 Jr"} 2015-12-12 12:12:12
	51 {"age":"40","name":"val_51 Jr"} 2015-12-12 12:12:12
	85 {"age":"40","name":"val_85 Jr"} 2015-12-12 12:12:12