KSQL insert into 语法

apacheheiz

KSQL语句 利用子查询向表中插入数据时报错，求助是不是KSQL的问题？这个KSQL我应该怎么写？
错误如下

1. Caused by: java.lang.RuntimeException: 执行ksql:insert into HEIZ_XETZD HEIZ_XETZD (HEIZ_XETZD.KCXED1_LSBH,HEIZ_KCDYD.KCXED1_SJDH) (select HEIZ_XETZD.KCXED1_LSBH,H
   
2. EIZ_XETZD.KCXED1_SJDH from HEIZ_XETZD HEIZ_XETZD where HEIZ_XETZD.KCXED1_LSBH = '31812')时出错！
   
3.         at DYProcess.dYProcessAfterStart(DYProcess.java:44)

复制代码

KSQL：

1. String insert_heiz_kcdyd = "insert into HEIZ_XETZD HEIZ_XETZD " +
   
2.                         "(HEIZ_XETZD.KCXED1_LSBH,HEIZ_KCDYD.KCXED1_SJDH) " +
   
3.                         "(select HEIZ_XETZD.KCXED1_LSBH,HEIZ_XETZD.KCXED1_SJDH from HEIZ_XETZD HEIZ_XETZD " +
   
4.                         "where HEIZ_XETZD.KCXED1_LSBH = '" + key + "')";
   
5. KSQL.executeUpdate(insert_heiz_kcdyd,null,"/DY_process/Dy_process/data",null);

复制代码

在这之前写了个update的KSQL：

1. String update_c10_kSql = "update KCXED1 KCXED1 set KCXED1.KCXED1_C10= 'justep' " +
   
2.                         "where KCXED1.KCXED1_LSBH = '" + key + "'";
   
3. KSQL.executeUpdate(update_c10_kSql,null,"/DY_process/Dy_process/data",null);

复制代码

运行正常

MaHZ

试试把别名改成不一样的HEIZ_XETZD，HEIZ_XETZD1

apacheheiz

MaHZ 发表于 2013-7-6 10:39
试试把别名改成不一样的HEIZ_XETZD，HEIZ_XETZD1

晕，复制粘贴的错。偷懒耽误事，insert into 的表明写错了~不好意思，占用大家时间了

apacheheiz

晕，复制粘贴的错。偷懒耽误事，insert into 的表名写错了~不好意思，占用大家时间了~~~~~ 结贴吧。将insert into 后面的 表名 改成正确的就对了~