exception“原子类型的表只能有一个字段”将数据流转换为表时

7eumitmz 于 2021-06-25 发布在 Flink

关注(0)|答案(1)|浏览(267)

1、 billcount和record是类对象。billcount对象的列是record的一些列。
2、 flink source正在从kafka topic获取“记录”数据。

case  class BillCount(logisId: Int, provinceId: Int, cityId: Int, orderRequVari: Int, orderRecAmount: Double, orderRecDate: Long)
val kafkaInputStream: DataStream[Record] = env.addSource(source)   //source is FlinkKafkaConsumer010 source
   val tbDataStream : DataStream[BillCount] = kafkaInputStream.map(
              new MapFunction[Record, BillCount] {
                override def map(value: Record) = {
                  BillCount(value.getLogis_id, value.getProvince_id, value.getCity_id,
                          value.getOrder_require_varieties, value.getOrder_rec_amount, value.getStore_rec_date.getTime)
    }
  })
 val stream = tbDataStream.toTable(tbEnv, 'logisId, 'provinceId, 'cityId, 'orderRequVari, 'orderRecAmount, 'orderRecDate) // occur error here

以下是例外情况：

Exception in thread "main" org.apache.flink.table.api.TableException: Table of atomic type can only have a single field.
at org.apache.flink.table.api.TableEnvironment$$anonfun$1.apply(TableEnvironment.scala:627)
at org.apache.flink.table.api.TableEnvironment$$anonfun$1.apply(TableEnvironment.scala:624)
at scala.collection.TraversableLike$$anonfun$flatMap$1.apply(TraversableLike.scala:251)
at scala.collection.TraversableLike$$anonfun$flatMap$1.apply(TraversableLike.scala:251)
at scala.collection.IndexedSeqOptimized$class.foreach(IndexedSeqOptimized.scala:33)
at scala.collection.mutable.ArrayOps$ofRef.foreach(ArrayOps.scala:108)
at scala.collection.TraversableLike$class.flatMap(TraversableLike.scala:251)
at scala.collection.mutable.ArrayOps$ofRef.flatMap(ArrayOps.scala:108)
at org.apache.flink.table.api.TableEnvironment.getFieldInfo(TableEnvironment.scala:624)
at org.apache.flink.table.api.StreamTableEnvironment.registerDataStreamInternal(StreamTableEnvironment.scala:398)
at org.apache.flink.table.api.scala.StreamTableEnvironment.fromDataStream(StreamTableEnvironment.scala:85)
at org.apache.flink.table.api.scala.DataStreamConversions.toTable(DataStreamConversions.scala:58)

scala apache-flink flink-sql

来源：https://stackoverflow.com/questions/46396706/exception-table-of-atomic-type-can-only-have-a-single-field-when-convert-data

1条答案

按热度按时间

qq24tv8q1#

billcount应该是一个pojo类。这意味着billcount类应该有一个默认构造函数（没有参数）和get/set函数。实验：

class BillCount{
    private int logisId;
    private int provinceId;
    private int cityId;

    BillCount(){}

    public void setLogisId(int logisId){
        this.logisId = logisId;
    }

    public void setProvinceId(int provinceId){
        this.provinceId = provinceId;
    }

    public void setCityId(int cityId){
        this.cityId = cityId;
    }

    public int getLogisId(){
        return this.logisId;
    }

    public int getProvinceId(){
        return this.provinceId;
    }

    public int getCityId() {
        return this.cityId;
    }

}

赞(0）回复(0）举报 2021-06-25

我来回答

exception“原子类型的表只能有一个字段”将数据流转换为表时

1条答案

相关问题

热门标签

最新问答