Drill uses backstick ` , in stead of single quota (').
Please try this :
use log.log;
SELECT * FROM `out.json` LIMIT 10;
On Thu, Aug 6, 2015 at 2:45 PM, Whitfield, Ryan <[email protected]>
wrote:
> I just started using drill and I am having issues doing simple queries on
> my json files. I made a storage plugin with a workspace pointing to the
> location of my JSON log files, but it won't let me perform a query.
> My storage plugin looks like this:
> {
> "type": "file",
> "enabled": true,
> "connection": "file:///",
> "workspaces": {
> "log": {
> "location": "/home/rwhitfield/log",
> "writable": false,
> "defaultInputFormat": null
> }
> }
> }
> Then when I run the following:
> use log.log;
> SELECT * FROM 'out.json' LIMIT 10;
> I get an error "PARSE ERROR: Encountered "\'out.json\'" at line 1, column
> 15. Am I making a stupid mistake somewhere? Appreciate any guidance!
> This message is intended only for the personal and confidential use of the
> recipients named above. If the
> reader of this email is not the intended recipient, you have received this
> email in error and any review,
> dissemination, distribution or copying is strictly prohibited. If you have
> received this email in error,
> please notify the sender immediately by return email and permanently
> delete the copy you received.
>
> This message is provided for informational purposes and should not be
> construed as a solicitation or
> offer to buy or sell any securities or related financial instruments.
> Wolverine is not responsible for any
> recommendation, solicitation, offer or agreement or any information about
> any transaction, customer
> account or account activity that may be attached to or contained in this
> communication. Wolverine
> accepts no liability for any content contained in the email, or any errors
> or omissions arising as a result
> of e-mail transmission. Any opinions contained in this email constitute
> the sender's best judgment at
> this time and are subject to change without notice.
>
