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?