Discussion:
Field name is not expected when use `AS` in sql expression
(too old to reply)
温晨欣
2017-05-04 02:53:18 UTC
Permalink
Raw Message
As shown above, when using the `SUM` expression in the SQL statement, the above problem occurs when using `AS`. The result record field is `$*`




Drill: Apache-drill-1.11.0

Table:




CREATE TABLE `req_search` (

`repo` text NOT NULL,

`appid` text NOT NULL,

`reqid` text NOT NULL,

`respTime` bigint(20) NOT NULL,

`respCode` bigint(20) NOT NULL,

`time_by_day` text

) ENGINE=InnoDB DEFAULT CHARSET=utf8
Jinfeng Ni
2017-05-04 05:19:05 UTC
Permalink
Raw Message
Looks like this user mailing list does not allow attached file. Can you
copy the output in text format and paste in email, so that people know what
you are referring to?
Post by 温晨欣
As shown above, when using the `SUM` expression in the SQL statement, the
above problem occurs when using `AS`. The result record field is `$*`
Drill: Apache-drill-1.11.0
CREATE TABLE `req_search` (
`repo` text NOT NULL,
`appid` text NOT NULL,
`reqid` text NOT NULL,
`respTime` bigint(20) NOT NULL,
`respCode` bigint(20) NOT NULL,
`time_by_day` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8
Loading...