Hello Khurram, > Do you use a username/password to connect to Drill, in your JDBC connection > string ?
LibreOffice Base does have inputs for Username and Password, but those are left empty. The connection string itself doesn't contain authentication information either, I simply use "jdbc:drill:drillbit=localhost". Since I'm running the default configuration, in embedded mode, no login is required. > What do the Drill logs say, the drillbit.log and drillbit.out files under > logs directory ? The .log isn't changed when trying to connect from Base. I guess that it's not even connecting, and thus there is no actual interaction with Drill. There is no drillbit.out file. > Can you connect to Drill from sqlline prompt ? Yes, that is possible: $ ./sqlline apache drill 1.14.0 "drill baby drill" sqlline> !connect jdbc:drill:drillbit=localhost Enter username for jdbc:drill:drillbit=localhost: Enter password for jdbc:drill:drillbit=localhost: 0: jdbc:drill:drillbit=localhost> (username and password left empty) After this, I can run queries. Also, at this point, the log now mentions the successful login. Actually, I'm not even sure if using Base to connect to Drill is something that should work. I don't know why not, but what do I know? I have some largish CSV-files, and trying to use LibreOffice Calc to create some pivot tables and nice charts to analyze the data. I'm hoping to use Drill as a fast and more versatile way of querying the CSV-files, and use Base to feed the data into Calc. Thanks, Randy
