| ==== |
| ---- QUERY |
| # alltypes has 7300 rows - codegen should be enabled if there |
| # are < 1000 backend daemons. |
| set disable_codegen_rows_threshold=8; |
| select count(*) from alltypes t1 |
| join alltypestiny t2 on t1.id = t2.id |
| ---- RESULTS |
| 8 |
| ---- TYPES |
| bigint |
| ---- RUNTIME_PROFILE |
| # Verify that codegen was enabled for join and scan |
| row_regex: .*Build Side Codegen Enabled.* |
| row_regex: .*TEXT Codegen Enabled.* |
| ==== |
| ---- QUERY |
| # alltypes has 7300 rows - codegen should be disabled regardless |
| # of # of backend impala daemons. |
| set disable_codegen_rows_threshold=8000; |
| select count(*) from alltypes t1 |
| join alltypestiny t2 on t1.id = t2.id |
| ---- RESULTS |
| 8 |
| ---- TYPES |
| bigint |
| ---- RUNTIME_PROFILE |
| # Verify that codegen was disabled |
| row_regex: .*Codegen Disabled: disabled due to optimization hints.* |
| ==== |
| ---- QUERY |
| # IMPALA-6435: codegen for NULL CHAR literals was broken. This query crashed |
| # impala without the fix. |
| set disable_codegen_rows_threshold=0; |
| select count(*) from ( |
| select cast('a' as char(4)) as s from functional.alltypestiny |
| union all |
| select cast('a' as char(4)) as s from functional.alltypestiny |
| union all |
| select cast(NULL as char(4)) as s from functional.alltypestiny |
| ) t |
| ---- RESULTS |
| 24 |
| ---- TYPES |
| bigint |
| ==== |
| ---- QUERY |
| # IMPALA-7032: Test that codegen gets disabled for CHAR type null literals in |
| # the backend. We force codegen to be on in order to exercise the codegen code |
| # for null literals. |
| set disable_codegen_rows_threshold=0; |
| select NULL from functional.alltypestiny |
| union select cast('a' as char(4)) from functional.alltypestiny |
| ---- RESULTS |
| 'a ' |
| 'NULL' |
| ---- TYPES |
| char |
| ==== |