AnsweredAssumed Answered

Drill not working on JSON file uploaded to MapR

Question asked by BOBcoupon on Jul 11, 2017
Latest reply on Jul 13, 2017 by maprcommunity

Hi - I uploaded my JSON files to Hadoop using WinSCP

 

However - I cannot use Drill on the files. Why not?

 

How can I create a table from a file that is put in Hadoop?

 

 

[mapr@maprdemo ~]$ hadoop fs -ls
Found 5 items
-rwxr-xr-x   1 mapr mapr          6 2017-07-11 09:50 .recent_tables
tr--------   - mapr mapr          2 2017-07-11 11:22 business
drwxr-xr-x   - mapr mapr          1 2017-04-21 18:56 drill
drwxr-xr-x   - mapr mapr          1 2017-04-21 18:50 tmp
drwxr-xr-x   - mapr mapr          0 2017-07-10 10:30 yelp
[mapr@maprdemo ~]$ cd yelp
[mapr@maprdemo yelp]$ ls
yelp_academic_dataset_business.json  yelp_academic_dataset_checkin.json  yelp_academic_dataset_review.json  yelp_academic_dataset_tip.json
[mapr@maprdemo yelp]$ sqlline
OpenJDK 64-Bit Server VM warning: ignoring option MaxPermSize=512M; support was removed in 8.0
apache drill 1.10.0
"a drill is a terrible thing to waste"
0: jdbc:drill:> select * from dfs.`/yelp/yelp_academic_dataset_business.json` limit 1;
Error: VALIDATION ERROR: From line 1, column 15 to line 1, column 17: Table 'dfs./yelp/yelp_academic_dataset_business.json' not found

SQL Query null

[Error Id: 303c7f8a-2d41-4da7-bc90-173770e63328 on 192.168.119.128:31010] (state=,code=0)

Outcomes