（Clickhouse-www.example.com，Oracle-11.2.0.3.0）.我的任务是将数据从Oracle表加载到Clickhouse表中（使用scala代码）。
在甲骨文中，表是用脚本 Package 的：

create table EAIST_LOT_SS
(
  id             NUMBER not null,
  registrynumber VARCHAR2(19) not null,
  tendersubject  VARCHAR2(2048),
  lotnumber      NUMBER not null,
  lotprice       NUMBER
);

column COLUMN_NAME format a15
column DATA_TYPE format a15

select column_name, data_type, nullable, data_length, data_precision, data_scale
from user_tab_columns where table_name ='EAIST_LOT_SS';

COLUMN_NAME     DATA_TYPE       NULLABLE DATA_LENGTH DATA_PRECISION DATA_SCALE
--------------- --------------- -------- ----------- -------------- ----------
ID              NUMBER          N                 22                
REGISTRYNUMBER  VARCHAR2        N                 19                
TENDERSUBJECT   VARCHAR2        Y               2048                
LOTNUMBER       NUMBER          N                 22                
LOTPRICE        NUMBER          Y                 22

字符串
在clickhouse中，表格上写满了脚本：

create table data.eaist_lot
(
  id                  UInt8 not null,
  registrynumber      FixedString(19) not null,
  tendersubject       FixedString(2048),
  lotnumber           Decimal64(18) not null,
  lotprice            Decimal64(18)
)ENGINE = MergeTree()
PRIMARY KEY (id);

型
scala代码，尝试在table中添加一行。

def saveToClickhouse(table: String, chConn: ClickHouseConnection): Unit = {
    val ps: PreparedStatement = chConn.prepareStatement(
      s"""insert into ${table}
        |select id, registrynumber, tendersubject, lotnumber, lotprice
        |from
        |input('id             UInt8,
        |       registrynumber FixedString(19),
        |       tendersubject  FixedString(2048),
        |       lotnumber      Decimal64(18),
        |       lotprice       Decimal64(18)
        |      ')
        |""".stripMargin)

    ps.setInt(1,1)
    ps.setString(2,"str 222")
    ps.setString(3,"str 333")
    ps.setDouble(4,1.2)
    ps.setDouble(5,2.3)

    ps.addBatch()
    ps.executeBatch()
  }

型
我有错误：线程"main"中的异常java. lang. IllegalArgumentException：BigDecliter（120000000000000000000000000）应该介于-100000000000000000000和10000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
在Clickhouse中，Number（不设置精度和比例）的最佳模拟是什么？