Thanks for filing the jira. I add the comment to JIRA. I'm also surprised that we did not hit this bug before. It seems to be related to the functions in the query.
On Fri, Apr 1, 2016 at 5:44 PM, John Omernik <[email protected]> wrote: > (By the way, thank you for validating, I apologize for not mentioning that. > It is appreciated) > > John > > On Fri, Apr 1, 2016 at 7:43 PM, John Omernik <[email protected]> wrote: > >> Done. >> >> https://issues.apache.org/jira/browse/DRILL-4572 >> >> Can you add your comment to the JIRA please? This seems like an odd bug, >> and I am surprised it hasn't come up, is using the results of functions as >> the aggregate field a rarity in Drill? >> >> On Fri, Apr 1, 2016 at 7:35 PM, Jinfeng Ni <[email protected]> wrote: >> >>> This seems to be a bug in the query planner. I could re-produce this >>> problem, with similar query, even on 1.4 and 1.5. >>> >>> select rtrim(s.name2) as name3 >>> from ( >>> select >>> ltrim(n_name) as `name2`, >>> count(*) as num_creates >>> from cp.`tpch/nation.parquet` >>> group by ltrim(n_name) >>> order by name2 ASC >>> ) s limit 100 >>> >>> Error: SYSTEM ERROR: AssertionError: Internal error: Type >>> 'RecordType(ANY $f0, BIGINT num_creates)' has no field 'name2' >>> >>> Could you please open a JIRA? Thanks. >>> >>> >>> >>> On Fri, Apr 1, 2016 at 4:53 PM, John Omernik <[email protected]> wrote: >>> > This may be from traveling all day, but I am running the query below and >>> > the error, I think it should work with the subquery, but yet, it is >>> > failing. This is via JDBC >>> > >>> > >>> > select date_part('year', s.cdate) as ydate from ( >>> > select >>> > to_date(createdon, 'yyyy-MM-dd HH:mm:ss') as `cdate`, count(*) as >>> > num_creates >>> > from >>> > view_mytable >>> > where >>> > createdon <> '0000-00-00 00:00:00' and createdon >= '2010-01-10' >>> > group by >>> > to_date(createdon, 'yyyy-MM-dd HH:mm:ss') >>> > order by cdate ASC >>> > ) s limit 100 >>> > >>> > SYSTEM ERROR: AssertionError: Internal error: Type 'RecordType(ANY $f0, >>> > BIGINT num_creates)' has no field 'cdate' >>> > [Error Id: 50caacaf-0b9b-4c1c-a3e1-53248bc385c0 on >>> > hadoopmapr6.brewingintel.com:31010] >>> > >>> > It's like my alias for the grouped field isn't actually taking.... this >>> > seems odd to me, or am I just really doing something weird here? >>> >> >>
