Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagejavascript
themeEclipse
titleCSV Protocol Handler
linenumberstrue
input = ACCESS({
                          source='CSVfridgeVibrationCSV',
                          wrapper='GenericPushGenericPull',
                          transport='File',
                          protocol='CSV',
                          datahandler='Tuple',
                          options=[
                            ['delimiter',','],
                            ['textDelimiter',"'"],
                            ['readfirstline','true'],
                            ['delay','100'],
                            ['filename', 'path to file']
                          ],
                          schema=[
                            ['symboldescription','StringDouble'],

                          ]             ['points','Double']
                                   ]
                        }                                            
                      )

CQL

Code Block
languagesql
themeEclipse
titleCSV Protocol Handler
linenumberstrue
CREATE STREAM csv (symbol String, points Double)   
    WRAPPER 'GenericPush'
    PROTOCOL 'CSV'
    TRANSPORT 'File'
    DATAHANDLER 'Tuple'
    OPTIONS ( 'delimiter' ',', 'textDelimiter' "'", 'readfirstline' 'true', 'delay' '100')