Also you can refer to [1] for the list of string functions implemented.
[1]
https://github.com/apache/drill/blob/master/exec/java-exec/src/main/java/org/apache/drill/exec/expr/fn/impl/StringFunctions.java
On Tue, Aug 30, 2016 at 11:06 AM, rahul challapalli <
challapallira...@gmail.com> wrote:
>
You should be able to use split_part function (I haven't tried it
myself...but it is supported). With this function you can extract
individual columns. Unfortunately I couldn't find the documentation for
this function as well. But it should be similar to how other databases
implement this
Hi,
Thanks - I think SPLIT gets me some of the way, but after the FLATTEN I
want to PIVOT, so instead of :
0: jdbc:drill:zk=cdh57-01-node-01.moffatt.me:> select
flatten(split(version,'.')) from sys.version;
+-+
| EXPR$0 |
+-+
| 1 |
| 7 |
| 0 |
+-+
I'd
It's traditional. We wait for the last minute to get our talk proposals
in for conferences.
Well, the last minute has arrived. The CFP for ApacheCon Seville closes
on September 9th, which is less than 2 weeks away. It's time to get your
talks in, so that we can make this the best ApacheCon yet.
Hello Sanjiv,
It is a simple select with no filters or conditions and a few casts going
against a database table. Can’t see how it could be possible to improve the
query. Drill will ask for the whole table.Are you accessing the data directly
in Drill through the cmd-line or using the web-ui