(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? >> > >
