Hi Xiaomeng, this definitely seems like a bug, but I can't reproduce it on the master branch. Can you tell me which version of Hive you are using?
On Wed, Jun 21, 2017 at 10:26 AM, Xiaomeng Huang <armon.hu...@gmail.com> wrote: > Hi, I missed a bug when use CTAS. > > 1. > hive> select 'test' as did from abc_test_old > > where did = '5FCAFD34-C124-4E13-AF65-27B675C945CC' limit 1; > OK > test > > > 2. > hive> create table abc_test_12345 as > > select 'test' as did from abc_test_old > > where did = '5FCAFD34-C124-4E13-AF65-27B675C945CC' limit 1; > > hive> select did from abc_test_12345 limit 1; > OK > 5FCAFD34-C124-4E13-AF65-27B675C945CC > > why result is not 'test'? > > 3. > hive> explain > > create table abc_test_12345 as > > select 'test' as did from abc_test_old > > where did = '5FCAFD34-C124-4E13-AF65-27B675C945CC' limit 1; > OK > STAGE DEPENDENCIES: > Stage-1 is a root stage > Stage-6 depends on stages: Stage-1 , consists of Stage-3, Stage-2, > Stage-4 > Stage-3 > Stage-0 depends on stages: Stage-3, Stage-2, Stage-5 > Stage-7 depends on stages: Stage-0 > Stage-2 > Stage-4 > Stage-5 depends on stages: Stage-4 > > STAGE PLANS: > Stage: Stage-1 > Map Reduce > Map Operator Tree: > TableScan > alias: abc_test_old > Statistics: Num rows: 32 Data size: 1152 Basic stats: COMPLETE > Column stats: NONE > Filter Operator > predicate: (did = '5FCAFD34-C124-4E13-AF65-27B675C945CC') > (type: boolean) > Statistics: Num rows: 16 Data size: 576 Basic stats: > COMPLETE Column stats: NONE > Select Operator > Statistics: Num rows: 16 Data size: 576 Basic stats: > COMPLETE Column stats: NONE > Limit > Number of rows: 1 > Statistics: Num rows: 1 Data size: 36 Basic stats: > COMPLETE Column stats: NONE > Reduce Output Operator > sort order: > Statistics: Num rows: 1 Data size: 36 Basic stats: > COMPLETE Column stats: NONE > Reduce Operator Tree: > Select Operator > expressions: '5FCAFD34-C124-4E13-AF65-27B675C945CC' (type: > string) > outputColumnNames: _col0 > Statistics: Num rows: 1 Data size: 36 Basic stats: COMPLETE > Column stats: NONE > Limit > Number of rows: 1 > Statistics: Num rows: 1 Data size: 36 Basic stats: COMPLETE > Column stats: NONE > File Output Operator > compressed: true > Statistics: Num rows: 1 Data size: 36 Basic stats: COMPLETE > Column stats: NONE > table: > input format: org.apache.hadoop.hive.ql.io. > orc.OrcInputFormat > output format: org.apache.hadoop.hive.ql.io. > orc.OrcOutputFormat > serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde > name: default.abc_test_12345 > > why expressions is '5FCAFD34-C124-4E13-AF65-27B675C945CC' ? >
