Drill Microsoft SQL plugin

Hi, I am using drill 1.4 in embedded mode. I am trying to add MS SQL server plugin in drill. I am referring: https://drill.apache.org/docs/rdbms-storage-plugin/#example-sql-server-configuration I got error: *error(unable to create/update plugin)* I am not able to see the logs in sqlline.log

Proper errors should be thrown on UI while failure in adding plugin

Hi All, When any plugin is added in drill with UI or via REST, we got *error(unable to create/update plugin) *in case of failure. This message is not sufficient, there should be "reason of failure" in the failure message. Regards, Devender

Re: Drill Microsoft SQL plugin

Hello If you cannot create the plugin that means that the connexion is not working.  The jdbc / mssql link is working for me :- I create a SQL user named drill2 within the Database- I check the jdbc connection with SQuirrel - here is my plugin parameters : {  "type": "jdbc",  "driver": "com.micro

Re: Drill Microsoft SQL plugin

I verified connection with squirrel client. I want to check logs for the error. This error cause must have logged somewhere but i am not able to find the logs. On 28-Jan-2016 7:20 PM, "Boris Chmiel" wrote: > Hello > If you cannot create the plugin that means that the connexion is not > working. T

Re: Proper errors should be thrown on UI while failure in adding plugin

I'm actually working on fixing this right now, I'm merging a simple fix for the annoyance that your changes get erased upon failure and then I will be working on improving the message. Watch https://issues.apache.org/jira/browse/DRILL-2653 for updates. - Jason On Thu, Jan 28, 2016 at 3:36 AM, De

Hangout notes from Tuesday

Quick PSA for anyone who sees these messages and wants to attend. We have a weekly google hangout on Tuesdays at 10am Pacific time. There are no requirements for showing up, anyone with an interest in Drill can join. We send out a message with the link as the meeting is starting as a reminder. Dri

Re: DATA_WRITE ERROR: Failed to drop table

Hi Kumiko, I have created a JIRA for this and posted a patch, please try building the branch in the PR linked here. [1] [1] - https://issues.apache.org/jira/browse/DRILL-4322 On Tue, Jan 26, 2016 at 12:56 PM, Kumiko Yada wrote: > Jason, > > I setup the environment, and I'm able to build/deploy

Set table creation format in a REST query call

I want to create most tables as parquet, but some other tables as json or csv. Currently, I am running all queries through the REST client so no session options are available. Is there a workspace feature for default output format or a REST query feature for output format? Thanks, Brent ᐧ

CTAS and storage format via REST API

We are using the REST API from nodejs and need to issue some create table statements that are a different format from the default for the system (currently Parquet). We cant issue an alter system command to change the store.format globally. I tried to issue multiple requests with a alter sessi

Re: CTAS and storage format via REST API

A few weeks ago a fix for this issue was merged, it requires using the new web UI security feature, which will hold onto a session while you are logged in. [1] You can try to build the tip of master yourself or wait for the upcoming 1.5.0 release to try it out. [1] - https://issues.apache.org/jir

Re: Set table creation format in a REST query call

A few weeks ago a fix for this issue was merged, it requires using the new web UI security feature, which will hold onto a session while you are logged in. [1] You can try to build the tip of master yourself or wait for the upcoming 1.5.0 release to try it out. [1] - https://issues.apache.org/jir

Re: Drill Microsoft SQL plugin

We had a similar issue with a heroku postgresql db. It turned out that it was because ssl mode is enforced (which is a good thing). There didn't seem to be an option for setting this via the storage params, but we found a workaround by modifying our url parameter as follows: "url": "jdbc:postgre

Re: DATA_WRITE ERROR: Failed to drop table

The patch was small and received a review quickly, so I merged it. You can just build the tip of master. On Thu, Jan 28, 2016 at 11:27 AM, Jason Altekruse wrote: > Hi Kumiko, > > I have created a JIRA for this and posted a patch, please try building the > branch in the PR linked here. [1] > > [1

RE: DATA_WRITE ERROR: Failed to drop table

Jason, I was able to build the PR with -Denforcer.skip=true option. However, I can no longer repro the bug. I was able to drop the table without an error. Thanks Kumiko From: Kumiko Yada Sent: Thursday, January 28, 2016 6:32 PM To: 'Jason Altekruse' Subject: RE: DATA_WRITE ERROR: Failed to d

Re: DATA_WRITE ERROR: Failed to drop table

Can you confirm what version of Maven you were running. It seems like some older versions of Maven have a bug that shows with our new build. (I've seen the problem on maven 3.0.5). thanks, jacques -- Jacques Nadeau CTO and Co-Founder, Dremio On Thu, Jan 28, 2016 at 7:29 PM, Kumiko Yada wrote:

Re: DATA_WRITE ERROR: Failed to drop table

It's the Maven 3.0.5. Thanks Kumiko From: Jacques Nadeau Sent: Thursday, January 28, 2016 7:50:47 PM To: user Cc: Jason Altekruse; Kevin Verhoeven; Ki Kang Subject: Re: DATA_WRITE ERROR: Failed to drop table Can you confirm what version of Maven you were

Re: Proper errors should be thrown on UI while failure in adding plugin

Thanks for replying Jason. I do believe logs must be saved somewhere whenever I fail in adding plugins (due to credential error or jar not added or whatever). Since I am using drill in embedded mode, logs must be saved in sqlline.log (correct me if I am wrong please) but I did not find any logs reg