From user-return-25648-archive-asf-public=cust-asf.ponee.io@flink.apache.org Tue Jan 29 16:38:53 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 3C4FF180625 for ; Tue, 29 Jan 2019 16:38:53 +0100 (CET) Received: (qmail 6093 invoked by uid 500); 29 Jan 2019 15:38:52 -0000 Mailing-List: contact user-help@flink.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list user@flink.apache.org Received: (qmail 6083 invoked by uid 99); 29 Jan 2019 15:38:52 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Jan 2019 15:38:52 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 9011518173F for ; Tue, 29 Jan 2019 15:38:51 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.047 X-Spam-Level: ** X-Spam-Status: No, score=2.047 tagged_above=-999 required=6.31 tests=[DKIMWL_WL_MED=-0.001, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd3-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024) with ESMTP id uvcafOVWXqVN for ; Tue, 29 Jan 2019 15:38:49 +0000 (UTC) Received: from mail-wr1-f50.google.com (mail-wr1-f50.google.com [209.85.221.50]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id 742825F1BD for ; Tue, 29 Jan 2019 15:29:05 +0000 (UTC) Received: by mail-wr1-f50.google.com with SMTP id x10so22509373wrs.8 for ; Tue, 29 Jan 2019 07:29:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=3zNr7yRk7agH/nBsAqwb7V0e6x5fYt9geF9Xw/Y7EDg=; b=fIholl1piG05dsdZXnV6wz3t57ubqTRGhWheiF8+IlWZfl+N1u5zW7veSSWmC8YGfu BZ2qlkPsDhRk4BcsQv+koIra3Q0NR5tmXAT35SxCwYRo7KadNSCoRrhCJ+4glLWI5poJ IdWrR/EFGGQAvi8/WyX2cZEIvUSob3mk1jwSxyEDY9W2M7oqUb2778J7p6MDYNuLFkBE xlUHpk8WfKFL/ZtPfpXO9M5tI5KllX2v3PuGDWR6s9qWaFChwAAN4di4c1YNpbB8ONTl oYsGFW1z5Dz+GScKm5W8k19EWt0wevWzPJGafkoZE/03qBeYWeFyRjpsxihNmo/cQfHb mrug== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=3zNr7yRk7agH/nBsAqwb7V0e6x5fYt9geF9Xw/Y7EDg=; b=MNJhXDUyb6D40mF7pQKUnutXcz134hOjsgMvf2sBeFeza4Ig4O/xbrlR1Zx/3MOkJp bm7f37cwfLFLirqQIdstzmnSYRLTexFWnMeeSIfBeIVfjL0tIeku5AY8xylhmVBPYAmG l4RLyMJ5UExNlwkhWKi9g9emZG77+79Q/QkryVjF3usWOH1n9vl8A03w4uIyAGMGhlJc Ja1bMm+GEKJog2AnOEaQ1zLyt5XQCREocv7OjN4zVbzI0dycODu/fm/reOAESjkP7gNk NZzUrwyDzgxxAD5XUmX/mLQ2vwBAy4PIeeGE4LAw5p9o/v5pJD1F9KvXnonVET2vVmVm dQRw== X-Gm-Message-State: AJcUukcQyIYlvVHM2XdYkCX4RmxM+1ADkIdKohFABAXpPgs9MnD8ZuZe Nks8iwYOciO/xwLXmUByfSr/oQF0pWsex4MKFGdZslBcSyE= X-Google-Smtp-Source: ALg8bN7TI0d3OQuUSNIKAOtFjaIYfGuRs5579ZSOBJELYLxz4rKttryydi2htfGLJTN30u45NoBnpNsCEFmftyytkbY= X-Received: by 2002:adf:9205:: with SMTP id 5mr26252852wrj.189.1548775744052; Tue, 29 Jan 2019 07:29:04 -0800 (PST) MIME-Version: 1.0 From: Soheil Pourbafrani Date: Tue, 29 Jan 2019 18:58:28 +0330 Message-ID: Subject: Select feilds in Table API To: user Content-Type: multipart/alternative; boundary="0000000000000fa34605809a7434" --0000000000000fa34605809a7434 Content-Type: text/plain; charset="UTF-8" Hi, I'm trying select some fields: lineitem .select( "l_returnflag," + "l_linestatus," + "l_quantity.sum as sum_qty," + "(l_extendedprice * (l_discount - 1)).sum as sum_disc_price," + "l_extendedprice.sum as sum_base_price," + "(l_extendedprice * (l_discount - 1) * (l_tax + 1)).sum as sum_charge," + "l_quantity.avg as avg_qty," + "l_extendedprice.avg as avg_price," + "l_discount.avg as avg_disc" ); But it errors: Cannot resolve field [l_returnflag] given input [TMP_2, TMP_5, TMP_1, TMP_0, TMP_4, TMP_6, TMP_3]. What is the problem? --0000000000000fa34605809a7434 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi,

I'm=C2=A0tryin= g select some fields:

lineitem
        .select(
           =
     "l_returnflag," +
                "l_linesta=
tus," +
                "l_quantity.sum as sum_qty," +
                "(l_extendedprice * (l_discount - 1)).=
sum as sum_disc_price," +
                "l_extendedprice.sum as sum_base_price," +
                "(l_exte=
ndedprice * (l_discount - 1) * (l_tax + 1)).sum as sum_charge," +
                "l_quantit=
y.avg as avg_qty," +
                "l_extendedprice.avg as avg_price," +
  =
              "l_discount.avg as=
 avg_disc"
        );
But it = errors:

Cannot resolve field [l_returnflag] given = input [TMP_2, TMP_5, TMP_1, TMP_0, TMP_4, TMP_6, TMP_3].

=
What is the problem?
--0000000000000fa34605809a7434--