随笔分类 - HANA
SAP HANA
摘要：6.SAP HANA CDS 使用SAP HANA Core Data Services（CDS）在SAP HANA Extended Application Services中构建设计时数据持久性模型。 CDS创建持久性Model类型： tables (entities) SQL views as
阅读全文
摘要：5.SAP HANA XS Job XS Job:定义重复执行的后台定期任务； 例如定时执行数据更新到Table的操作，需要使用到XS Job; SAP HANA XS Setting up Scheduled jobs steps: Step Task User Role Tool 1 Creat
阅读全文
摘要：5. Imperative SQLScript Logic 5.1 Scalar Variables /* 4. Imperative SQLScript Logic 4.1 Scalar Variables DECLARE <sql_identifier> [{,<sql_identifier>
阅读全文
摘要：4. Declarative SQLScript Logic 4.1 Table Parameter /* 3.Declarative SQLScript Logic 3.1Table Parameter <table_param> ::= [IN|OUT] <param_name> {<table
阅读全文
摘要：3Logic Container /* 2.Logic Container 逻辑代码块分类：1.Procedure;2.User-Defined Function User-Defined Function分类：Scalar User-Defined Function and Table User-
阅读全文
摘要：2 Data Type Extension /* 2.Data Type Extension --创建table数据类型 CREATE TYPE <type_name> AS TABLE (<column_list_definition>) <column_list_definition> ::=
阅读全文
摘要：4.SAP HANA SQL Script 4.1 Orchestration Logic 1.Orchestration Logic 示例：orchestrationProc CREATE PROCEDURE orchestrationProc LANGUAGE SQLSCRIPT READS S
阅读全文
摘要：3.12 Aggregate Functions /*12. Aggregate Functions*/ /* Aggregate functions are analytic functions that calculate an aggregate value based on a group
阅读全文
摘要：/* 154.YEAR(<date>) 返回年 YEARS_BETWEEN(<date_1>, <date_2>) 返回两个日期之间年份 */ SELECT YEAR (TO_DATE ('2011-05-30', 'YYYY-MM-DD')) FROM DUMMY; --返回2 SELECT YE
阅读全文
摘要：153. XMLEXTRACT XMLEXTRACT(<XML_document>, <XPath_query> [,<NamespaceDeclarations>]) <XML_document> Specifies an XML document of type CLOB, NCLOB, VAR
阅读全文
摘要：/* 149.WEEK WEEK(<date>) 返回周数 WEEKDAY(<date>) 返回日期所在周天，星期1（0）~星期天(6) */ SELECT WEEK(TO_DATE('2011-05-30', 'YYYY-MM-DD')) FROM DUMMY; SELECT WEEK ('201
阅读全文
摘要：/* 148.VAR Aggregate function: VAR( [ ALL | DISTINCT ] <expression> ) Window function: VAR( <expression> ) <window_specification> Returns the variance
阅读全文
摘要：/* 144. UCASE UCASE(<string>) 将字符串字符转换大写 UPPER(<string>) */ SELECT UCASE ('Ant') FROM DUMMY; SELECT UPPER ('Ant') FROM DUMMY; /* 145. UMINUS UMINUS(<n
阅读全文
摘要：/* 141.TAN TAN(<number>) 返回正切值 TANH(<number>) 返回指定数值参数的双曲正切值。 */ SELECT TAN (0.0) FROM DUMMY; SELECT TANH(1) FROM DUMMY; /* 142. 类型转换 TO_ALPHANUM(<val
阅读全文
摘要：/* 121. SCORE SCORE() Returns the relevance of a record that has been found. */ SELECT SCORE(),"Content" FROM SEARCH_TEXT WHERE CONTAINS("Content", 'c
阅读全文
摘要：/* 112. RAND RAND() 返回double类型伪随机数，不可以用于安全和加密 RANDOM_PARTITION(<training_set_size>, <validation_set_size>, <test_set_size>, <seed>) <window_specificat
阅读全文
摘要：/* 111. QUARTER QUARTER(<date>, [, <start_month> ]) 返回日期季度 <start_month>：指定第一季度开始月份，没有指定默认1月 */ --2011-Q4,201201是2011年第四季度 SELECT QUARTER (TO_DATE('20
阅读全文
摘要：/* 107. PERCENT_RANK PERCENT_RANK() <window_specification> */ SELECT "CLASS", "VAL", "OFFSET", PERCENT_RANK() OVER (PARTITION BY "CLASS" ORDER BY "VAL
阅读全文
摘要：/* 106. OCCURRENCES_REGEXPR OCCURRENCES_REGEXPR( <pattern> [ FLAG <flag> ] IN <regex_subject_string> [ FROM <start_position> ] ) 返回正则匹配次数 <pattern> ::
阅读全文
摘要：/* 100.NCHAR NCHAR(<number>) 将数字转换为Union编码字符 */ SELECT NCHAR(65) FROM DUMMY; /* 101.NEWUID 在SAP HANA数据库创建唯一标识符 */ SELECT NEWUID() FROM DUMMY; /* 102.
阅读全文
