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.i...@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? >
