Apache drill GUI SQuirrel on Windows Class not found
I am trying to use Apache drill GUI on windows 10, I have followed all the instructions on their link https://drill.apache.org/docs/using-jdbc-with-squirrel-on-windows/ , adding the driver shows the message Driver class org.apache.drill.jdbc.Driver successfully registered for driver definition: test but when creating an alias and testing the connection, it says
Drill JDBC Driver alias: JDBC Driver class not found
class java.lang.ClassNotFoundException: org.eclipse.jetty.server.Handler
I have also tried adding the E:\apache-drill-1.16.0\jars\3rdparty and E:\apache-drill-1.16.0\jars\classb folder paths when adding the driver. But in vain, please help me in this regard.
Please use connection string to connect to Drill instance instead of using a connection string which tries to start Drill in embedded mode: jdbc:drill:zk=local. For example, you may start Drill in embedded mode using drill-embedded script or using sqlline, as was described here: https://drill.apache.org/docs/starting-drill-on-windows/ and connect to it using jdbc:drill:drillbit=localhost connection string.
Regarding the correct error message, squirrelsql handles exceptions in their own way, but it is possible to make changes in Drill to enforce squirrelsql to specify the correct exception. I have created Jira for this: https://issues.apache.org/jira/browse/DRILL-7461
- Json schema array of objects (where objects must be the same)
- JSON Schema for objects without names
- JSON Schema to validate an array of dictionaries
- How can I JSON stringify and then parse an object with functions? (JavaScript)
- Rails: Serializing deeply nested associations with active_model_serializers
- (Python) Cant scrape data from rocket tracker using re, requests, and json
- How to send data from Python script to JavaScript and vice-versa?
- How to minify json files while Vite build?
- How to fix 'Private field must be declared in an enclosing class'
- Extract arrays from JSON
- Python Json loads() returning string instead of dictionary?
- PowerShell code returning specific variable. Enhance program by capturing variables above and below
- How to unpack nested JSON into Python Dataclass
- Group by a part of json array column
- php CURL Error: Request payload is not JSON
- How to resolve 400 bad request error while trying to send message through the new FCM API V1?
- PowerShell code returning correct value. However, looking to enhance program by capturing the ID tag listed above the desired value
- java.lang.IllegalStateException: Expected BEGIN_OBJECT but was STRING at line 1 column 2 path $
- json schema validate the value of one property against the value of another property
- Can comments be used in JSON?
- Blazor requesting a json file
- How to JQ select a record where a sub-node matches both values
- No column name was specified for column 1 of 'sp'
- Round numbers anywhere in a JSON document
- How to pull application version (or import package.json file)? Google does not help :(
- How can I create a JSON object that can handle conditionals?
- Create JSON from CSV and add some header lines with Pandas
- Convert JSON type scraped string to dataframe in R
- How do I decode HTML entities in Swift?
- BudiBase request returns different results in JSON and Raw