How to query a Json file without using JDBC connector?

[marc nicole]

Hi,

I want to query a JSON file placed in Desktop folder (Windows).
How to do that in Java ?

PS: i saw this type of code :

Connection con = null;

      con = new Driver().connect(DRILL_JDBC_LOCAL_URI, getDefaultProperties());
      Statement stmt = con.createStatement();
      ResultSet rs = stmt.executeQuery(DRILL_SAMPLE_QUERY);...


But that requires using JDBC and to place JSON in jar file within CP of
Drill which i don't want;

Thanks.