You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Sungwook Yoon <sy...@maprtech.com> on 2015/10/13 22:24:03 UTC

quote in storage plugin

I have an apache access log.
It is " " separated '"' quoted string per line.

In the storage plugin, I defined the storage plugin as,
"ssv": {
      "type": "text",
      "extensions": [
        "ssv"
      ],
      "delimiter": " ",
      "quote": "\""
    },

The "quote" field, is accepted but after update on the storage plugin, with
success message, "quote" field disappears.

WHY?

I tried to define the "quote" as "\u0022". Again disappears with success
message.

Then, drill fails to read the data correctly, ignoring the "quoted" value
direction.

What should I do in this case?

Thanks,

Sungwook

Re: quote in storage plugin

Posted by Sungwook Yoon <sy...@maprtech.com>.
Andries,

I put quote before the delimiter declaration, did not change the behavior.
That is, the "quote" field disappears after successful update.

I tried "\u0000".
With this, storage plugin updates successfully and changes the storage
plugin definition.

But, of course, this is not helping the situation in terms of querying.

Thanks,

Sungwook


On Tue, Oct 13, 2015 at 4:38 PM, Andries Engelbrecht <
aengelbrecht@maprtech.com> wrote:

> Does the quote field in the SP config disappear after you click update?
> Did you check if it works if you put it before delimiter?
>
> Have you tried "quote": "\u0000"?
>
>
> —Andries
>
>
> > On Oct 13, 2015, at 1:24 PM, Sungwook Yoon <sy...@maprtech.com> wrote:
> >
> > I have an apache access log.
> > It is " " separated '"' quoted string per line.
> >
> > In the storage plugin, I defined the storage plugin as,
> > "ssv": {
> >      "type": "text",
> >      "extensions": [
> >        "ssv"
> >      ],
> >      "delimiter": " ",
> >      "quote": "\""
> >    },
> >
> > The "quote" field, is accepted but after update on the storage plugin,
> with
> > success message, "quote" field disappears.
> >
> > WHY?
> >
> > I tried to define the "quote" as "\u0022". Again disappears with success
> > message.
> >
> > Then, drill fails to read the data correctly, ignoring the "quoted" value
> > direction.
> >
> > What should I do in this case?
> >
> > Thanks,
> >
> > Sungwook
>
>

Re: quote in storage plugin

Posted by Andries Engelbrecht <ae...@maprtech.com>.
Does the quote field in the SP config disappear after you click update?
Did you check if it works if you put it before delimiter?

Have you tried "quote": "\u0000"?


—Andries


> On Oct 13, 2015, at 1:24 PM, Sungwook Yoon <sy...@maprtech.com> wrote:
> 
> I have an apache access log.
> It is " " separated '"' quoted string per line.
> 
> In the storage plugin, I defined the storage plugin as,
> "ssv": {
>      "type": "text",
>      "extensions": [
>        "ssv"
>      ],
>      "delimiter": " ",
>      "quote": "\""
>    },
> 
> The "quote" field, is accepted but after update on the storage plugin, with
> success message, "quote" field disappears.
> 
> WHY?
> 
> I tried to define the "quote" as "\u0022". Again disappears with success
> message.
> 
> Then, drill fails to read the data correctly, ignoring the "quoted" value
> direction.
> 
> What should I do in this case?
> 
> Thanks,
> 
> Sungwook