I've run across this issue as well, in my opinion the CTAS should complete without complaint as you can create views on empty tables in RDBMSs.
Chris Matta [email protected] 215-701-3146 On Thu, Oct 22, 2015 at 1:25 PM, Neeraja Rentachintala < [email protected]> wrote: > Hsuan > Is there is a JIRA for this? > > On Thu, Oct 22, 2015 at 10:11 AM, Hsuan Yi Chu <[email protected]> > wrote: > > > Hi, > > This is known issue. It is because there is no schema with empty.tsv > file. > > > > I think Daniel might be trying to address this issue. > > > > Thanks for bringing this up. > > > > On Wed, Oct 21, 2015 at 8:10 PM, chandan prakash < > > [email protected]> > > wrote: > > > > > Hi, > > > I have to run CTAS on a tsv file which might in some cases be empty . > > > In those cases its giving NPE. > > > > > > java.sql.SQLException: SYSTEM ERROR: NullPointerException > > > > > > Fragment 0:0 > > > > > > [Error Id: 4aa5a127-b2dd-41a0-ac49-fc2058e9564f on 192.168.0.104:31010 > ] > > > > > > at org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally( > > > DrillCursor.java:214) > > > > > > at org.apache.drill.jdbc.impl.DrillCursor.loadInitialSchema( > > > DrillCursor.java:257) > > > > > > saw *similar bug post : > https://issues.apache.org/jira/browse/DRILL-3539 > > > <https://issues.apache.org/jira/browse/DRILL-3539>* > > > > > > Can anyone help with the fix or some workaround ? > > > Any lead will be appreciated . > > > > > > Thanks, > > > Chandan > > > > > > > > > -- > > > Chandan Prakash > > > > > >
