Here is an example using the drill sandbox
curl \
> --header "Content-type: application/json" \
> --request POST \
> --data '{
> "queryType" : "SQL",
> "query" : "select t.user_info.cust_id as custid, t.user_info.device as
device,t.user_info.state as state from dfs.clicks.`clicks/clicks.json` t
limit 5"
> }' \
> http://192.168.48.129:8047/query.json
[ {
"state" : "il",
"device" : "IOS5",
"custid" : 22526
}, {
"state" : "nc",
"device" : "AOS4.2",
"custid" : 16368
}, {
"state" : "oh",
"device" : "IOS6",
"custid" : 21449
}, {
"state" : "oh",
"device" : "IOS5",
"custid" : 20323
}, {
"state" : "ca",
"device" : "IOS5",
"custid" : 15360
} ]
On Tue, Dec 9, 2014 at 3:28 PM, Carol McDonald <[email protected]>
wrote:
> here is an example
>
> [image: Inline image 1]
>
> [image: Inline image 2]
>
> On Tue, Dec 9, 2014 at 12:16 PM, Yash Sharma <[email protected]> wrote:
>
>> Hi Carol,
>> Drill has a rest interface which works on JSON. You can check the Drill
>> web
>> interface at http://localhost:8047/status when the Drillbit is running.
>> It
>> would be great if you would like to enhance the interface.
>>
>> You can also check out DrillRoot.java for little more implementation
>> details:
>>
>> https://github.com/apache/drill/blob/9e164662f5296f7048c880c40bc551030fb58cca/exec/java-exec/src/main/java/org/apache/drill/exec/server/rest/DrillRoot.java
>>
>> Please feel free to join the Drill Hangout today - 10am PDT (Tuesday)
>> where
>> we can discuss areas that you are interested in.
>>
>> Good luck Drilling !!
>>
>> On Tue, Dec 9, 2014 at 10:32 PM, prasanna pradhan <[email protected]>
>> wrote:
>>
>> > This should help
>> >
>> > https://docs.google.com/document/d/1mRsuWk4Dpt6ts-
>> > jQ6ke3bB30PIwanRiCPfGxRwZEQME/edit
>> >
>> >
>> > On Tuesday 09 December 2014 10:24 PM, Carol Bourgade wrote:
>> >
>> >> I am interested in writing a web app using REST and drill to query
>> json
>> >> files, HBase... Where can I find more information about the drill REST
>> >> interface?
>> >> Does the Drill Rest interface accept application/json content type ?
>> >>
>> >>
>> >
>>
>
>
