Assuming your storage plugin is named 'dfs', the below query should work. (Note: We should use backticks instead of single quotes around the filename string)
select * from dfs.log.`out.json`; - Rahul 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. >
