[ https://issues.apache.org/jira/browse/DRILL-4575?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15228817#comment-15228817 ]
Hugo Bellomusto commented on DRILL-4575: ---------------------------------------- It sounds different, in DRILL-4572 error happens when using functions. Here, I use a function to make it work. > alias not working on field. > --------------------------- > > Key: DRILL-4575 > URL: https://issues.apache.org/jira/browse/DRILL-4575 > Project: Apache Drill > Issue Type: Bug > Affects Versions: 1.6.0 > Environment: Apache drill 1.6.0 > java 1.7.0_40 > Reporter: Hugo Bellomusto > > {code:sql} > create table dfs.tmp.a_field as > select 'hello' field from (VALUES(1)); > select field my_field from dfs.tmp.a_field; > {code} > The result is: > ||field|| > |hello| > When should be: > ||my_field|| > |hello| > {noformat:title=physical plan} > 00-00 Screen : rowType = RecordType(ANY field): rowcount = 1.0, cumulative > cost = {1.1 rows, 1.1 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 1635 > 00-01 Scan(groupscan=[ParquetGroupScan [entries=[ReadEntryWithPath > [path=hdfs://10.70.168.69:8020/tmp/a_field]], > selectionRoot=hdfs://10.70.168.69:8020/tmp/a_field, numFiles=1, > usedMetadataFile=false, columns=[`field`]]]) : rowType = RecordType(ANY > field): rowcount = 1.0, cumulative cost = {1.0 rows, 1.0 cpu, 0.0 io, 0.0 > network, 0.0 memory}, id = 1634 > {noformat} > But, this works well: > {code:sql} > select concat(field, ' world') my_field from dfs.tmp.a_field; > {code} > returns: > ||my_field|| > |hello world| > Additional info: > {code:sql} > select * from sys.options where name like '%parquet%' or string_val like > '%parquet%'; > {code} > ||name||string_val| > |store.format|parquet| > |store.parquet.block-size| | > |store.parquet.compression|snappy| > |store.parquet.dictionary.page-size| | > |store.parquet.enable_dictionary_encoding| | > |store.parquet.page-size| | > |store.parquet.use_new_reader| | > |store.parquet.vector_fill_check_threshold| | > |store.parquet.vector_fill_threshold| | -- This message was sent by Atlassian JIRA (v6.3.4#6332)