drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Dunning <ted.dunn...@gmail.com>
Subject Re: select from table with options
Date Wed, 21 Oct 2015 05:20:43 GMT
On Tue, Oct 20, 2015 at 5:35 PM, Jacques Nadeau <jacques@dremio.com> wrote:

> ** (4) Solve with specific syntax for the most common scenarios (very
> declarative) **
>   select * FROM
>   mydb.mytable
>     TREAT AS TEXT
>       USING
>         LINE DELIMITER '\n'
>         AND FIELD DELIMITER ','
>         AND TREAT FIRST ROW AS HEADERS
>
>
> I'm actually most inclined to the fourth. It seems like the most user
> friendly. From a grammar perspective, I think you need to figure out a way
> to use TREAT AS as a grammar switch so we can avoid protecting these
> expressions in all contexts. What is nice about this pattern is that is
> understandable by non-technical users and fits sql. Hiding things in a
> table function makes things more complex.
>

This fourth is also least extensible and thus most disenfranchising for
those outside the inner group.

Table functions (hopefully) would be something that others could implement.

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message