[
https://issues.apache.org/jira/browse/DRILL-4421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15156118#comment-15156118
]
Lunen edited comment on DRILL-4421 at 2/21/16 6:01 PM:
-------------------------------------------------------
WORKING:
SELECT
field1 AS renamed1 ,field2 AS renamed2 ,field3 AS renamed3 ,field4
AS renamed4 ,field5 AS renamed5 ,
field6 AS renamed6,field7 AS renamed7 ,field8 AS renamed8 ,field9
AS renamed9 ,field10 AS renamed10,
field11 AS renamed11,field12 AS renamed12,field13 AS renamed13,field14
AS renamed14,field15 AS renamed15,
field16 AS renamed16,field17 AS renamed17,field18 AS renamed18,field19
AS renamed19,field20 AS renamed20
FROM
MSSQL.`dbo`.`tableName` limit 10
NOT WORKING:
SELECT
field1 AS renamed1 ,field2 AS renamed2 ,field3 AS renamed3 ,field4
AS renamed4 ,field5 AS renamed5 ,
field6 AS renamed6,field7 AS renamed7 ,field8 AS renamed8 ,field9
AS renamed9 ,field10 AS renamed10,
field11 AS renamed11,field12 AS renamed12,field13 AS renamed13,field14
AS renamed14,field15 AS renamed15,
field16 AS renamed16,field17 AS renamed17,field18 AS renamed18,field19
AS renamed19,field20 AS renamed20,
field21 AS renamed21
FROM
MSSQL.`dbo`.`tableName` limit 10
WORKING WOULD BRING BACK:
renamed1 | renamed2 | renamed3 | etc
NOT WORKING WOULD BRING BACK:
field1 | field2 | field3 | etc
was (Author: lunendl):
WORKING:
SELECT
field1 AS renamed1 ,field2 AS renamed2 ,field3 AS renamed3 ,field4
AS renamed4 ,field5 AS renamed5 ,
field6 AS renamed6,field7 AS renamed7 ,field8 AS renamed8 ,field9
AS renamed9 ,field10 AS renamed10,
field11 AS renamed11,field12 AS renamed12,field13 AS renamed13,field14
AS renamed14,field15 AS renamed15,
field16 AS renamed16,field17 AS renamed17,field18 AS renamed18,field19
AS renamed19,field20 AS renamed20
FROM
MSSQL.`dbo`.`tableName` limit 10
NOT WORKING:
SELECT
field1 AS renamed1 ,field2 AS renamed2 ,field3 AS renamed3 ,field4
AS renamed4 ,field5 AS renamed5 ,
field6 AS renamed6,field7 AS renamed7 ,field8 AS renamed8 ,field9
AS renamed9 ,field10 AS renamed10,
field11 AS renamed11,field12 AS renamed12,field13 AS renamed13,field14
AS renamed14,field15 AS renamed15,
field16 AS renamed16,field17 AS renamed17,field18 AS renamed18,field19
AS renamed19,field20 AS renamed20,
field21 AS renamed21
FROM
MSSQL.`dbo`.`tableName` limit 10
> Renaming more than 20 fields does not work.
> --------------------------------------------
>
> Key: DRILL-4421
> URL: https://issues.apache.org/jira/browse/DRILL-4421
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.5.0
> Reporter: Lunen
> Priority: Critical
>
> I've noticed that when there are more than 20 fields, all renamed field names
> gets dropped.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
