drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Madhu Borkar <backmeup...@gmail.com>
Subject Re: How to load data in Drill
Date Wed, 20 Nov 2013 02:31:59 GMT
Hi Ben,
apache-drill-1.0.0-m1 is drill version,I installed binary.
I have attached log herewith.
Is my pig script looks okay to generate parquet fiel?
Thanks
-Madhu


On Tue, Nov 19, 2013 at 9:34 AM, Ben Becker <bbecker@maprtech.com> wrote:

> Hi Madhu,
>
> Could you report which version you're using (e.g. 1.0.0-m1.rc3), and attach
> the logs when this happens?  You can use Lilith to view the logs if you
> like (see instructions at the bottom of this
> page<
> https://cwiki.apache.org/confluence/display/DRILL/How+To+Run+Drill+with+Sample+Data#
> >
> ).
>
> Thanks,
> Ben
>
>
> On Mon, Nov 18, 2013 at 10:16 PM, Madhu Borkar <backmeupone@gmail.com
> >wrote:
>
> > I have devlopment MapR cluster. I have installed Apache Drill using
> > binaries. I could run queries with sample-data.
> >
> > I decided to load test data using pig. Here is my code
> >
> > ---------------------------------
> >
> > REGISTER file:/home/mapr/lib/parquet-pig-bundle-1.2.5.jar
> >
> > data = LOAD '$DATA'
> >
> >                 USING PigStorage(',')
> >
> > as (
> >
> >       user:    chararray,
> >
> >       street: chararray,
> >
> >       state:          chararray,
> >
> >       city:           chararray,
> >
> >       type:  chararray
> >
> >   );
> >
> >
> >
> > A = LIMIT data 3;
> >
> > dump A;
> >
> > fs -rmr /mapr-hive/parquet/data;
> >
> > STORE data INTO '/mapr-hive/parquet/data' using
> > parquet.pig.ParquetStorer();
> >
> > ----------------------
> >
> > Pig script writes to output. I moved data under apache drill directory.
> >
> >
> >
> > select * from "real-data/users.parquet";
> >
> >
> >
> > but when I try to query this data I get rpc error?
> >
> > Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure
> while
> > running query.[error_id: "04ac52e4-b49e-45b8-82c5-cf480154eefd"
> >
> > endpoint {
> >
> >   address: "Node.etouch.net"
> >
> >   user_port: 31010
> >
> >   bit_port: 32011
> >
> > }
> >
> > error_type: 0
> >
> > message: "Failure while running fragment. < NullPointerException"
> >
> > ]
> >
> >
> >
> > Please, provide me help how to load data in Apache Drill.?
> >
> > Is there MapR configuration needed for Drill?
> >
> > Regards
> >
>

Mime
  • Unnamed multipart/mixed (inline, None, 0 bytes)
View raw message