Select feilds in Table API

[Soheil Pourbafrani]

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?

[Fabian Hueske-2]

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 <[hidden email]>:

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?