Mailing-List: contact drill-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: drill-dev@incubator.apache.org
Received-SPF: pass (nike.apache.org: domain of hzhu@maprtech.com designates
 209.85.212.173 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAPct2GTHi8NiX3e3g01Q1yCxLKUNP5RJGgA79Jf1kqX7S8juZQ@mail.gmail.com>
References: 
 <CAPct2GTHi8NiX3e3g01Q1yCxLKUNP5RJGgA79Jf1kqX7S8juZQ@mail.gmail.com>
Date: Mon, 24 Nov 2014 14:04:36 -0800
Message-ID: 
 <CA+dwJQCX6nwdtU9SnubRRNs_yzFf0e8nqXj+cwpmg+LMZRd0xg@mail.gmail.com>
Subject: Re: Create table with auto increment column
From: Hao Zhu <hzhu@maprtech.com>
To: drill-user@incubator.apache.org
Cc: drill-dev@incubator.apache.org,
 =?UTF-8?B?S2F6aSBTw6FuZG9y?= <kazi@tmit.bme.hu>
Content-Type: multipart/alternative; boundary=f46d04428f4af73be30508a1fa4b

--f46d04428f4af73be30508a1fa4b
Content-Type: text/plain; charset=UTF-8

Seems window functions are not in Drill yet.
https://issues.apache.org/jira/browse/DRILL-1454

Thanks,
Hao

On Sat, Nov 22, 2014 at 6:50 AM, lapro1 <lapro1@gmail.com> wrote:

> Hi,
> I tried to create a table with auto increment column in drill, as I could
> do it in hive before, but it dropped exception. I think I didn't write it
> in adequate syntax.
>
> This was the query:
> create table hive_hosts_with_rank(hostname, id) as select columns[0],
> rank() over (order by columns[1]) from dfs.`/tmp/hosts/0_0_0.csv`;
>
> I got the exception:
> ------------+------------+
> |     ok     |  summary   |
> +------------+------------+
> | false      | Error: Node [rel#5528:Subset#11.PHYSICAL.SINGLETON([]).[]]
> coul |
> +------------+------------+
> 1 row selected (0.956 seconds)
>
>
> Does anybody know, how can I create a column like it,
>
> Thanks the answer in advance,
> Laszlo
>

--f46d04428f4af73be30508a1fa4b--