[DRILL-1614] CTAS is broken - throws RuntimeException and Reader error

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.7.0
• Assignee: Parth Chandra
• Reporter: Abhishek Girish
• Created: 30/Oct/14 20:23
• Updated: 08/May/15 13:54
• Resolved: 17/Nov/14 01:40

Description

CTAS is broken

Create table as statements fail with the below error:

Query failed: Failure while running fragment.

java.lang.RuntimeException: java.sql.SQLException: Failure while executing query.
at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
at sqlline.SqlLine.print(SqlLine.java:1809)
at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
at sqlline.SqlLine.dispatch(SqlLine.java:889)
at sqlline.SqlLine.begin(SqlLine.java:763)
at sqlline.SqlLine.start(SqlLine.java:498)
at sqlline.SqlLine.main(SqlLine.java:460)

LOG:
2014-10-29 16:24:20,236 [f9e93ef8-20c8-46da-9675-5384269f8c21:frag:0:0] WARN o.a.d.e.vector.complex.fn.JsonReader - Error reported. Quit writing
2014-10-29 16:24:20,413 [f9e93ef8-20c8-46da-9675-5384269f8c21:frag:0:0] WARN o.a.d.e.w.fragment.FragmentExecutor - Error while initializing or executing fragment

The first CTAS statement usually succeeds and all subsequent statements fail.

Tried on JSON and Text