第52页,共53页。 显示 529 条结果 (0.112 秒)
migrate.xml
选值列表。\n- **能力**:基于该模型能够执行MQL语句,MQL是一种JSON格式表示的SQL语句,不支持嵌套\n- **取数方法**:exec_olap_query( mql, model_id, params) #执行模型取数,返回的结果是一个DataFrame,mql是一种类SQL语句,params是模型参数数组。\n\n---\n# 示例部分\n## **mql**示例:mql是一种类SQL语句,以下是针对不同问句,mql生成示例\n假如表信息如下:\nTableName:合同事实表\n- 年, 类型:text, 数据格式:yyyy(示例:2016)\n- 年季, 类型:text, 数据格式:yyyyQQ(示例工作日.xml
":"SQL语句(只限于where之后语句,如:name = zs)","type":"string","desc":null,"required":null,"typeOptions":null,"options":null,"value":"","isHidden":null,"disable":null,"controlETL工具Kettle用户手册.pdf
的 Java Script 值(Modified Java Script Value) ................................ 127 9.6.47 执行 SQL 语句(Execute SQL script … 完全可以帮助你实现这些。事实上,大多数的 DDL,例 如“create/alter table”、“create index”或者“create sequence”命令可能通过 SQL 编辑器窗口运行。 注:多个 SQL 语句时必须用“;”隔开。 4.2 屏幕截图 选择创建的数据库连接,然后点击鼠标右键,即可打开SQl脚本节点语法使用说明.pdf
..............................................................................................................5 2.3 WHERE 条件语句..........................................................................................................6 2.4 DISTINC 去重 … 示例:select * from TempView0 示例:SELECT 1+1 2.2 AS 更改字段名 示例:select Col0 as id from TempView0 2.3 WHERE 条件语句 操作符:= < <= > >= <> AND OR LIKE 示例:select Col0,Col1,Col2SQl脚本节点语法使用说明.pdf
..............................................................................................................5 2.3 WHERE 条件语句..........................................................................................................6 2.4 DISTINC 去重 … 示例:select * from TempView0 示例:SELECT 1+1 2.2 AS 更改字段名 示例:select Col0 as id from TempView0 2.3 WHERE 条件语句 操作符:= < <= > >= <> AND OR LIKE 示例:select Col0,Col1,Col2SmartbiMPP(Clickhouse).xml
="onLinkClick" moduleType="ClientSide" name="3_4_执行SQL语句查询_action" disabled="false" order="0"><script><![CDATA[function paramToString(v) { return v == null ? null : v.toString(); } function main(spreadsheetReport, ruleName, params) { if (ruleName != "3_4_执行SQL语句查询") return; //@smartbi.openOtherPagemigrate.xml
":{"innerControl":"jdbcFeatures"}}},{"name":"whereSql","lable":"SQL语句(只限于where之后语句,如:name = zs)","type":"string","desc":null,"required":null,"typeOptions":null … ","controlProps":{"innerControl":"jdbcFeatures"}}},{"name":"whereSql","lable":"SQL语句(只限于where之后语句,如:name = zs)","type":"string","desc":null,"required":null,"typeOptionsmigrate.xml
spreadsheetReport.spreadsheetReportWriteBack.setWriteBackCellData(row + 1, col + 0, newIdValue, newIdValue); }; /** * 执行SQL语句,获取结果集 */ function getSqlResult() { var util = jsloader.resolvemigrate.xml
spreadsheetReport.spreadsheetReportWriteBack.setWriteBackCellData(row + 1, col + 0, newIdValue, newIdValue); }; /** * 执行SQL语句,获取结果集 */ function getSqlResult() { var util = jsloader.resolve添加新行自动为单元格赋值.xml
} } /** * 执行SQL语句,获取结果集 */ function getSqlResult() { var util = jsloader.resolve("freequery.common.util"); var ret = util.remoteInvoke