drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bob Rumsby <brum...@maprtech.com>
Subject Re: Querying JSON files on HDFS
Date Wed, 29 Oct 2014 17:08:59 GMT
The Drill Tutorial is here:
https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+Tutorial

On Wed, Oct 29, 2014 at 7:44 AM, mufy <mufeed.usman@gmail.com> wrote:

> You'll need to create a storage plugin for JSON as,
>
> {
> "type": "file",
> "enabled": true,
> "connection": "hdfs:///",
> "workspaces": {
> "root": {
> "location": "/",
> "writable": false,
> "storageformat": "json"
> }
> },
> "formats": {
> "json": {
> "type": "json"
> }
> }
> }
>
> And you should be able to query the file as shown below,
>
> select count(1) from json.root.`sample.json`;
>
>
> Where sample.json will be your file on the HDFS.
>
>
>
>
>
> ---
> Mufeed Usman
> My LinkedIn <http://www.linkedin.com/pub/mufeed-usman/28/254/400> | My
> Social Cause <http://www.vision2016.org.in/> | My Blogs : LiveJournal
> <http://mufeed.livejournal.com>
>
>
>
>
> On Wed, Oct 29, 2014 at 8:09 PM, Daniel Haviv <danielrulez@gmail.com>
> wrote:
>
> > Hi,
> > I can't find a tutorial explaining how to get started with Drill (besides
> > querying the sample data that comes with Drill).
> >
> > I have some json data on HDFS that I would like to query, how do I query
> > these files ?
> > I know I need to do some configuration for Drill to know HDFS there is no
> > info about how to..
> >
> > Thanks,
> > Daniel
> >
>

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