Hi Sean,
I poked around in the source code. Drill has something called a "plugin
registry" that holds plugin definitions. This code is case insensitive, but
should preserve name case.
Also, Drill uses a "CaseInsensitivePersistentStore" to write to the local file
system in embedded mode. This store converts plugin names to lower case for
storage. If you edit storage by hand, you should ensure that your plugin names
are all lower case so that Drill can find them.
Thanks,
- Paul
On Friday, February 14, 2020, 6:54:26 PM PST, Paul Rogers
<[email protected]> wrote:
Hi Sean,
Drill works best when it runs as a server, using ZK for persistent storage and
coordination. That said, in embedded mode Drill is supposed to save plugins to
local storage. The changes between your manual edits and what Drill sees are:
* Workspace names are lower-cased. I'm not sure if this is a bug or feature, my
guess would be a bug.
* Drill uses the name "writable". You used the common misspelling "writeable",
so Drill ignored your property.
How are you enabling/disabling plugins? Via the web UI? Manually in your file?
Thanks,
- Paul
On Friday, February 14, 2020, 6:42:57 PM PST, Prabhakar Bhosaale
<[email protected]> wrote:
Hi,
I faced this problem when I start the drill with drill-embedded.bat. and it
was resolved by starting drill using sqlline.bat -u "jdbc:drill:zk=local
Give it a try.
Regards
Prabhakar
On Fri, Feb 14, 2020, 03:09 Leyne, Sean <[email protected]> wrote:
>
> I created a new storage plug-in (copying the system defined 'cp'
> definition), and I am now trying to changes the configuration.
>
> First, enable/disable plug-in action is not having any effect.
>
> Second, when I shutdown the embedded engine, and make manual changes to
> the xxxx.sys.drill file in my C:\tmp\drill\sys.storage_plugins folder, the
> changes are only partially accepted.
>
> This is definition in the xxxx.sys.drill file:
>
> {
> "type" : "file",
> "connection" : "file:///",
> "config" : null,
> "workspaces" : {
> "CSVFiles": {
> "location": "d:/drill/CSVFiles/",
> "writeable": false
> },
> "ParquetFiles": {
> "location": "d:/drill/ParquetFiles/",
> "writeable": true
> }
> },
> "formats" : {...
>
> This is what the WebUI is displaying
>
> {
> "type": "file",
> "connection": "file:///",
> "config": null,
> "workspaces": {
> "csvfiles": {
> "location": "d:/drill/CSVFiles/",
> "writable": false,
> "defaultInputFormat": null,
> "allowAccessOutsideWorkspace": false
> },
> "parquetfiles": {
> "location": "d:/drill/ParquetFiles/",
> "writable": false,
> "defaultInputFormat": null,
> "allowAccessOutsideWorkspace": false
> }
> },
> "formats": {
>
> Note: the "parquetfiles" | "writable" are different.
>
> Finally, trying to edit the "parquetfiles" | "writable" via the WebUI
> plugin configuration editor but the changes are not being saved/don't have
> any effect.
>
> What am I doing wrong?
>
>
> Sean
>
>
