You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by chandan prakash <ch...@gmail.com> on 2015/10/22 05:10:08 UTC
CTAS over empty file throws NPE
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
Re: CTAS over empty file throws NPE
Posted by Christopher Matta <cm...@mapr.com>.
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
cmatta@mapr.com
215-701-3146
On Thu, Oct 22, 2015 at 1:25 PM, Neeraja Rentachintala <
nrentachintala@maprtech.com> wrote:
> Hsuan
> Is there is a JIRA for this?
>
> On Thu, Oct 22, 2015 at 10:11 AM, Hsuan Yi Chu <hy...@maprtech.com>
> 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 <
> > chandanbaranwal@gmail.com>
> > 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
> > >
> >
>
Re: CTAS over empty file throws NPE
Posted by Hsuan Yi Chu <hy...@maprtech.com>.
https://issues.apache.org/jira/browse/DRILL-3249 (for tsv, csv)
https://issues.apache.org/jira/browse/DRILL-3539 (for json)
On Thu, Oct 22, 2015 at 10:25 AM, Neeraja Rentachintala <
nrentachintala@maprtech.com> wrote:
> Hsuan
> Is there is a JIRA for this?
>
> On Thu, Oct 22, 2015 at 10:11 AM, Hsuan Yi Chu <hy...@maprtech.com>
> 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 <
> > chandanbaranwal@gmail.com>
> > 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
> > >
> >
>
Re: CTAS over empty file throws NPE
Posted by Abdel Hakim Deneche <ad...@maprtech.com>.
Chandan actually found the JIRA:
https://issues.apache.org/jira/browse/DRILL-3539
On Thu, Oct 22, 2015 at 10:25 AM, Neeraja Rentachintala <
nrentachintala@maprtech.com> wrote:
> Hsuan
> Is there is a JIRA for this?
>
> On Thu, Oct 22, 2015 at 10:11 AM, Hsuan Yi Chu <hy...@maprtech.com>
> 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 <
> > chandanbaranwal@gmail.com>
> > 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
> > >
> >
>
--
Abdelhakim Deneche
Software Engineer
<http://www.mapr.com/>
Now Available - Free Hadoop On-Demand Training
<http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available>
Re: CTAS over empty file throws NPE
Posted by Neeraja Rentachintala <nr...@maprtech.com>.
Hsuan
Is there is a JIRA for this?
On Thu, Oct 22, 2015 at 10:11 AM, Hsuan Yi Chu <hy...@maprtech.com> 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 <
> chandanbaranwal@gmail.com>
> 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
> >
>
Re: CTAS over empty file throws NPE
Posted by Hsuan Yi Chu <hy...@maprtech.com>.
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 <ch...@gmail.com>
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
>