I am a new user of Drill .. I have spent the last week obsessively watching
every video I could find .. the technology is very exciting. I am particularly
interested in using Drill over Azure Blob Store to read our Json Time Series
Data. I have started working through the examples in the documentation and have
come across a blocker at the query functions at
https://drill.apache.org/docs/query-directory-functions/
I have setup the examples according to instructions but am getting the
following error:
org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR:
Unexpected internal error near index 1 \ ^ [Error Id:
97b39db3-bbbf-46fb-89a3-4862acbebe67 on darlo:31010]
I also get this error when trying to query a directory using my own examples
which I have been working up. I have installed my test environment on a 64 bit
Win10 machine using Drill 1.4.0.
I managed to locate Drill 1.3.0 and the examples above which fail in 1.4 worked
as expected in 1.3
Hope you can provide some inisight into this problem.
I would move forward with my testing using 1.3 except that I have blocker there
also where Drill is applying the incorrect type to my decimal data and we do
not have the:
ALTER SESSION SET `store.json.read_numbers_as_double` = true;
Command available.
Thanks in advance.
John Darlington | CTO
Switch Automation<http://www.switchautomation.com/>
"Connected Buildings. Smarter Operations. Better Business."
0412 550 379 | Skype: john-darlington | @SwitchHQ<https://twitter.com/switchhq>
503-505 Kent St, Sydney
