Skip to Content
avatar image
Former Member

Compilation error in Smart Data Streaming- Hana Developer edition data flow

Hi Experts,

Created a demo in SDS on HANA Developer Edition SPS 11(version- 1.00.112.00.1457525470 (fa/newdb100_rel)) running on Azure.

During the compilation, I am getting the below error

Compiling project sds_poc2
[ESP-3-158005] Invalid syntax at or before "VALUES". Please verify that the syntax is correct. Using a keyword without quotes for an identifier could also give this error. line 7 column 0
Unable to compile project sds_poc2

Please find the CCL code of the demo,

CREATE INPUT STREAM NEWSTREAM SCHEMA (ID integer ,
value integer ); /**@SIMPLEQUERY=FILTER*/
CREATE OUTPUT STREAM Filter1 SCHEMA (
ID integer ,
VALUES integer )
AS
SELECT * FROM NEWSTREAM WHERE
NEWSTREAM.value > 50 ; ATTACH OUTPUT ADAPTER HANA_Output1 TYPE hana_out
TO Filter1
PROPERTIES
service = 'sds_new' ,
sourceSchema = 'SAP_HANA_STREAMING' ,
table = 'SDS_POC' ;

Thanks,

Regards,

Deva

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 25, 2016 at 06:08 PM

    This error is expected because "VALUES" is a keyword. The list of keywords can be found in the documentarion: Appendix: List of Keywords

    As stated in the documentation: "Keywords cannot be used as identifiers for any CCL objects"

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 25, 2016 at 08:00 PM

    Thank you so much Rob.

    I changed to "TEMP" and there is no error now.

    Regards,

    Deva

    Add comment
    10|10000 characters needed characters exceeded