flink-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Soheil Pourbafrani <soheil.i...@gmail.com>
Subject Select feilds in Table API
Date Tue, 29 Jan 2019 15:28:28 GMT
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