| --! qt:dataset:src1 | |
| --! qt:dataset:src | |
| set hive.auto.convert.join=false; | |
| set hive.cbo.enable=false; | |
| select | |
| a.key, b.value, c.value | |
| from | |
| src a, | |
| src1 b, | |
| src1 c | |
| where | |
| a.key = b.key and a.key = c.key | |
| and b.key != '' and b.value != '' | |
| and a.value > 'wal_6789' | |
| and c.value > 'wal_6789' | |
| ; |