flink-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fabian Hueske <fhue...@gmail.com>
Subject Re: Select feilds in Table API
Date Tue, 29 Jan 2019 18:13:51 GMT
The problem is that the table "lineitem" does not have a field
"l_returnflag".
The field in "lineitem" are named [TMP_2, TMP_5, TMP_1, TMP_0, TMP_4,
TMP_6, TMP_3].

I guess it depends on how you obtained lineitem.

Best, Fabian

Am Di., 29. Jan. 2019 um 16:38 Uhr schrieb Soheil Pourbafrani <
soheil.ir08@gmail.com>:

> 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?
>

Mime
View raw message