各位专家好请问GaussDB for InfluxDB支持混合云HCS部署么？支持线下IEF或者IES部署么？感谢

专家好    请问GaussDB for InfluxDB支持混合云HCS部署么？支持线下IEF或者IES部署么？感谢

DWS 号称 多模数据库，多模体现在哪些方面，支持关系型数据库，文档性数据库，图数据库 ？

【功能模块】【操作步骤&问题现象】第一次查看gsql脚本，有个问题请教下，在gsql脚本中，有变量的使用，如select xxx from ${ETL_DATA}.XXXX，我理解里面的${ETL_DATA}是变量，但是我搜索了整个脚本文件，没有发现这个变量是在哪里定义的，没太理解，这个变量是如何赋值的，【截图信息】【日志信息】（可选，上传日志内容或者附件）

同样的一个FUNCTION函数在C80SPC200中调用存储过程DBMS_OUTPUT.PUT_LINE可以看到每一步的输出打印，但是在8.0版本函数运行中调用存储过程DBMS_OUTPUT.PUT_LINE打印是看不到每一步的信息的，只有任务执行完或者杀掉任务后才能看到。想知道8.0版本是否是做了哪些限制？是否可以通过开启什么参数也可以在任务执行中可以查看到每一步的输出打印？

【功能模块】【操作步骤&问题现象】在通过外表将数据插入到目标表的时候，出现以下错误error: dn_6021_6022: dn_6041_6042: could not read source file: /opt/input_data/wt_i.txt, because the resource of file has been released,这是什么原因导致的？【截图信息】【日志信息】（可选，上传日志内容或者附件）

1、增加节点，新节点密码不知道是什么，必须重置密码才能登陆2、删除节点，只删了前台的Proxy，而后台的server并没有删除。相关测试文章：《华为云GaussDB(for Redis)数据库——在线加减节点及扩容》https://www.modb.pro/db/42243

项目中存在大量调用存储过程返回游标的场景，想在不改动java代码的前提，如何让GaussDB 200 存储过程适配java当前java调用GaussDB 200 存储过程报错，获取不到游标的值。报错： You may wish to exclude one of them to ensure predictable runtime behavior 2020-12-14 16:50:22,071 [main] DEBUG [com.huawei.it.finioc.dao.IFiniocGaussDao.finiocGaussFunNewTest] ==>  Preparing: {call DWRSALES.proc_test_lyt( ?, ?, ?, ?) }2020-12-14 16:50:22,081 [main] DEBUG [com.huawei.it.finioc.dao.IFiniocGaussDao.finiocGaussFunNewTest] ==> Parameters: 1(String), 1(String), YYY(String) org.springframework.jdbc.BadSqlGrammarException:### Error querying database.  Cause: com.huawei.gauss200.jdbc.util.PSQLException: A CallableStatement function was executed and the out parameter 1 was of type java.sql.Types=1111 however type java.sql.Types=-10 was registered.### The error may exist in file [D:\Idea\Jalor6\cnbgioc_develop\om.impl\target\classes\com\huawei\it\finioc\dao\IFiniocGaussDao.xml]### The error may involve com.huawei.it.finioc.dao.IFiniocGaussDao.finiocGaussFunNewTest-Inline### The error occurred while setting parameters### SQL: {call DWRSALES.proc_test_lyt(       ?,       ?,       ?,       ?)    }### Cause: com.huawei.gauss200.jdbc.util.PSQLException: A CallableStatement function was executed and the out parameter 1 was of type java.sql.Types=1111 however type java.sql.Types=-10 was registered.; bad SQL grammar []; nested exception is com.huawei.gauss200.jdbc.util.PSQLException: A CallableStatement function was executed and the out parameter 1 was of type java.sql.Types=1111 however type java.sql.Types=-10 was registered.          at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)         at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)         at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74)         at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)         at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159)         at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)         at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:57)         at com.huawei.it.finioc.dao.FiniocGaussDaoTest.finiocGaussFunNewTest(FiniocGaussDaoTest.java:50)         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)         at java.lang.reflect.Method.invoke(Method.java:498)         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)         at java.lang.reflect.Method.invoke(Method.java:498)         at org.springframework.test.context.junit4.statements.RunBeforeTestExecutionCallbacks.evaluate(RunBeforeTestExecutionCallbacks.java:74)         at org.springframework.test.context.junit4.statements.RunAfterTestExecutionCallbacks.evaluate(RunAfterTestExecutionCallbacks.java:84)         at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)         at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)         at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)         at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:251)         at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97)         at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)         at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)         at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:190)         at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)         at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)         at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:220)         at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:53)Caused by: com.huawei.gauss200.jdbc.util.PSQLException: A CallableStatement function was executed and the out parameter 1 was of type java.sql.Types=1111 however type java.sql.Types=-10 was registered.         at com.huawei.gauss200.jdbc.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:473)         at com.huawei.gauss200.jdbc.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:415)         at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)         at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)         at java.lang.reflect.Method.invoke(Method.java:498)         at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)         at org.apache.ibatis.executor.statement.CallableStatementHandler.query(CallableStatementHandler.java:68)         at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)         at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)         at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)         at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)         at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)         at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)         at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)         at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)         at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)         at java.lang.reflect.Method.invoke(Method.java:498)         at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)         ... 22 more

    报错内容： Found multiple occurrences of org.json.JSONObject on the class path:jar:file:/D:/mvn_repository/org/json/json/20180813/json-20180813.jar!/org/json/JSONObject.classjar:file:/D:/mvn_repository/com/vaadin/external/google/android-json/0.0.20131108.vaadin1/android-json-0.0.20131108.vaadin1.jar!/org/json/JSONObject.classYou may wish to exclude one of them to ensure predictable runtime behavior2020-12-14 16:50:22,071 [main] DEBUG [com.huawei.it.finioc.dao.IFiniocGaussDao.finiocGaussFunNewTest] ==>  Preparing: {call DWRSALES.proc_test_lyt( ?, ?, ?, ?) } 2020-12-14 16:50:22,081 [main] DEBUG [com.huawei.it.finioc.dao.IFiniocGaussDao.finiocGaussFunNewTest] ==> Parameters: 1(String), 1(String), YYY(String)org.springframework.jdbc.BadSqlGrammarException: ### Error querying database.  Cause: com.huawei.gauss200.jdbc.util.PSQLException: A CallableStatement function was executed and the out parameter 1 was of type java.sql.Types=1111 however type java.sql.Types=-10 was registered.### The error may exist in file [D:\Idea\Jalor6\cnbgioc_develop\om.impl\target\classes\com\huawei\it\finioc\dao\IFiniocGaussDao.xml]### The error may involve com.huawei.it.finioc.dao.IFiniocGaussDao.finiocGaussFunNewTest-Inline### The error occurred while setting parameters### SQL: {call DWRSALES.proc_test_lyt(       ?,       ?,       ?,       ?)    }### Cause: com.huawei.gauss200.jdbc.util.PSQLException: A CallableStatement function was executed and the out parameter 1 was of type java.sql.Types=1111 however type java.sql.Types=-10 was registered.; bad SQL grammar []; nested exception is com.huawei.gauss200.jdbc.util.PSQLException: A CallableStatement function was executed and the out parameter 1 was of type java.sql.Types=1111 however type java.sql.Types=-10 was registered.at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:101)at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:74)at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159)at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:57)at com.huawei.it.finioc.dao.FiniocGaussDaoTest.finiocGaussFunNewTest(FiniocGaussDaoTest.java:50)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at java.lang.reflect.Method.invoke(Method.java:498)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at java.lang.reflect.Method.invoke(Method.java:498)at org.springframework.test.context.junit4.statements.RunBeforeTestExecutionCallbacks.evaluate(RunBeforeTestExecutionCallbacks.java:74)at org.springframework.test.context.junit4.statements.RunAfterTestExecutionCallbacks.evaluate(RunAfterTestExecutionCallbacks.java:84)at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75)at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86)at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84)at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:251)at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97)at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:190)at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:33)at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:220)at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:53)Caused by: com.huawei.gauss200.jdbc.util.PSQLException: A CallableStatement function was executed and the out parameter 1 was of type java.sql.Types=1111 however type java.sql.Types=-10 was registered.at com.huawei.gauss200.jdbc.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:473)at com.huawei.gauss200.jdbc.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:415)at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:94)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at java.lang.reflect.Method.invoke(Method.java:498)at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:59)at org.apache.ibatis.executor.statement.CallableStatementHandler.query(CallableStatementHandler.java:68)at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:83)at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)at java.lang.reflect.Method.invoke(Method.java:498)at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)... 22 moreDisconnected from the target VM, address: '127.0.0.1:49938', transport: 'socket'Process finished with exit code -1  

线下GaussDB A 8.0.0有实时数仓的功能么？

DWS作为实时数仓，官网上资料太少了，能多提供些资料么？实时数仓原理，使用手册，优化手册，还有性能指标（单节点入库TPS和单节点读取TPS）

【功能模块】【操作步骤&问题现象】客户现场发现这样一个问题，a表字段1left join b表字段2a表字段1：char(6)b表字段1：varchar(200)发现关系不上，是什么原因？如果要想关联这两个字段，要如何处理？【截图信息】【日志信息】（可选，上传日志内容或者附件）

使用最新的FusionCare对新装集群进行巡检，发现存在“检查网卡RXTX值”的不合格项。客户服务器是ARM架构，操作系统是CentOS 7.6客户执行操作：ethtool -G 网卡名 rx 参数 tx 参数  发现服务器直接下电了，其他节点无法ping通该节点，想知道这个操作是否是正常情况？

【问题描述】查看集群状态，实例处于build failed状态【问题分析】实例处于build failed一般有以下几个原因：1）xlog被回收2）build过程中与主机网络断连（主机故障或者网络原因）3）build超时具体原因需要查看对应节点gs_ctl日志进行排查【修复方案】1）在任意节点执行：cm_ctl build -n 1 -D /srv/BigData/mppdb/data2/slave1 -b full -t 10800-t 代表build超时参数2）在需要build实例所在节点执行：gs_ctl build -D /srv/BigData/mppdb/data2/slave1 -Z datanode -b full -r 10800-r 用于调整build超时参数

【问题现象】Console页面点击查看监控指标按钮后进入CES页面不显示DWS集群监控信息。【分析过程】对于HCS环境，登录OC页面，进入资源监控->云资源->数据仓库服务选择数据仓库节点，检查是否节点数和dws实例数量相同通过DWS运维容器，进入dws实例，检查/home/Ruby/log/ces/ces.log文件，检查是否出现The post request return code is:200, content is success信息使用ntpq -p命令，检查是否出现时钟不同步的问题【解决方案】若在资源监控->云资源->数据仓库服务页面中，存在某些节点监控不到的情况，通过id在dws数据库中查询到dws实例名称，登录问题实例若ces.log中未出现The post request return code is:200, content is success的信息，检查/home/Ruby/InitCes.json文件中ak sk信息，如果有更新，修改InitCes.json并保存若节点村子啊ntp服务不同步问题，会导致上传监控信息失败，需要同步ntp时间后，检查ces.log中上报监控信息的状态