Hey, SQL UNION operator and AVRO UNION type are two different things. The latter isn't supported yet. You can watch DRILL-3565 <https://issues.apache.org/jira/browse/DRILL-3565>for updates on this.
Regards, Abhishek On Sat, Aug 15, 2015 at 1:36 PM, Kartik Bhatia <[email protected]> wrote: > Hi, > I am getting the following error while I try to run avro file. > > 0: jdbc:drill:zk=local> SELECT * FROM > dfs.`C:\Users\kb97407\Downloads\apache-dri > ll-1.1.0.tar\apache-drill-1.1.0\apache-drill-1.1.0\sample-data\sample1.avro` > LIMIT 3; > Error: SYSTEM ERROR: UnsupportedOperationException: Unimplemented type: > UNION > > Fragment 0:0 > > [Error Id: 33464d39-0730-4fdd-b881-136543323e5e on > L_PBL2T91.scif.com:31010] (st > ate=,code=0) > > However according to drill documentation see below (it says feature is > supported) > > SQL UNION Improvements > > We've enhanced support for SQL UNION functionality. Drill now supports > both UNION and UNION ALL capabilities. We've also improved the query > optimizer to better optimize plans that include the UNION clause. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > This e-mail message from State Compensation Insurance Fund and all > attachments transmitted with it > may be privileged or confidential and protected from disclosure. If you > are not the intended recipient, > you are hereby notified that any dissemination, distribution, copying, or > taking any action based on it > is strictly prohibited and may have legal consequences. If you have > received this e-mail in error, > please notify the sender by reply e-mail and destroy the original message > and all copies. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >
