Return-Path: 
 <drill-dev-return-9425-apmail-incubator-drill-dev-archive=incubator.apache.org@incubator.apache.org>
X-Original-To: apmail-incubator-drill-dev-archive@minotaur.apache.org
Delivered-To: apmail-incubator-drill-dev-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id DE2DFCBF4
	for <apmail-incubator-drill-dev-archive@minotaur.apache.org>;
 Sat, 22 Nov 2014 14:50:54 +0000 (UTC)
Received: (qmail 35938 invoked by uid 500); 22 Nov 2014 14:50:54 -0000
Delivered-To: apmail-incubator-drill-dev-archive@incubator.apache.org
Received: (qmail 35827 invoked by uid 500); 22 Nov 2014 14:50:54 -0000
Mailing-List: contact drill-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:drill-dev-help@incubator.apache.org>
List-Unsubscribe: <mailto:drill-dev-unsubscribe@incubator.apache.org>
List-Post: <mailto:drill-dev@incubator.apache.org>
List-Id: <drill-dev.incubator.apache.org>
Reply-To: drill-dev@incubator.apache.org
Delivered-To: mailing list drill-dev@incubator.apache.org
Received: (qmail 35803 invoked by uid 99); 22 Nov 2014 14:50:53 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 22 Nov 2014 14:50:53 +0000
X-ASF-Spam-Status: No, hits=1.7 required=5.0
	tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of lapro1@gmail.com designates
 209.85.215.47 as permitted sender)
Received: from [209.85.215.47] (HELO mail-la0-f47.google.com) (209.85.215.47)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 22 Nov 2014 14:50:27 +0000
Received: by mail-la0-f47.google.com with SMTP id hz20so5598321lab.6
        for <multiple recipients>; Sat, 22 Nov 2014 06:50:26 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:date:message-id:subject:from:to:content-type;
        bh=I/BzlZoo3Vm0fjtjFsHJWTw5Dw7i0mVNoZEgVHCwOPk=;
        b=uQR7CdcBmJpK1vmyJGgy3hI1gf38CE7atEAZFONp7uOELAwhZgcAVuSDvSru0zJhvl
         3enUByf/ythPU6I0SxiJLl1aUVRdAW+d4WaPwoKOWZXzrd8CHxdBb0Ay2dDQM/v8jQbE
         7+K0JSNuuVTfPfeV+vGO/pXEzn9DIvdVHbTEiI8YunI4eCxFEFqr7smU6ZoxWGD7JlkG
         DbOwBfxDiWldKKWu392MLDjn8yRUlxuCqyKQdZLSeiwcNu7UPJjOcnIrTeL7N8MNjBI3
         QJBa6X6zSjjEQrIfExn84lc61FjqUFTo3MKEPwSjBvd1VZlyzdtX0b6cKPvdj5vM+62p
         l+mA==
MIME-Version: 1.0
X-Received: by 10.152.23.103 with SMTP id l7mr9881752laf.92.1416667826794;
 Sat, 22 Nov 2014 06:50:26 -0800 (PST)
Received: by 10.114.70.111 with HTTP; Sat, 22 Nov 2014 06:50:26 -0800 (PST)
Date: Sat, 22 Nov 2014 15:50:26 +0100
Message-ID: 
 <CAPct2GTHi8NiX3e3g01Q1yCxLKUNP5RJGgA79Jf1kqX7S8juZQ@mail.gmail.com>
Subject: Create table with auto increment column
From: lapro1 <lapro1@gmail.com>
To: drill-dev@incubator.apache.org, drill-user@incubator.apache.org,
	=?UTF-8?B?S2F6aSBTw6FuZG9y?= <kazi@tmit.bme.hu>
Content-Type: multipart/alternative; boundary=089e0158c31894b5c7050873ae4e
X-Virus-Checked: Checked by ClamAV on apache.org

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

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

--089e0158c31894b5c7050873ae4e--