I think the error is not with storage plugin but with query parsing here is the exception 0: jdbc:drill:zk=local> select max(last_name) last_name from cp.`employee.json` group by last_name limit 5; Error: VALIDATION ERROR: From line 1, column 8 to line 1, column 21: Aggregate expression is illegal in GROUP BY clause
On Fri, Apr 19, 2019 at 11:57 PM Kunal Khatua <ku...@apache.org> wrote: > (Replying on the Drill user list) > > This is odd. The CP storage plugin is inbuilt with Drill and that hasn't > changed. 1.15 by itself works fine. > > What is the error you are seeing, Nitin? > > > On 4/18/2019 10:58:48 PM, Nitin Pawar <nitinpawar...@gmail.com> wrote: > Hi, > > We are trying to upgrade drill from 1.13 to 1.15 > following query works in drill 1.13 but not in 1.15 > > select max(last_name) from cp.`employee.json` group by last_name limit 5 > > can you let us know if this backward compatibility issue will be fixed ?? > > -- > Nitin Pawar > -- Nitin Pawar