title: CREATE TABLE Failed. [3707] Syntax error,
body: <p>when i am trying to create a table like below</p>
  
  <pre><code>CREATE SET TABLE pp_scratch.HADOOP_FPTI_DASHBOARD ,NO FALLBACK ,
       NO BEFORE JOURNAL,
       NO AFTER JOURNAL,
       CHECKSUM = DEFAULT,
       DEFAULT MERGEBLOCKRATIO
       (
       id decimal(10,0) NOT NULL  GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, MAXVALUE 999999999999, NO CYCLE)
        job_status VARCHAR(32) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
        current_processing_hr VARCHAR(32) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
        no_of_files_moved VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL)
  PRIMARY INDEX  id;
  </code></pre>
  
  <blockquote>
    <p>CREATE TABLE Failed.  [3707] Syntax error, expected something like a
    name or a Unicode delimited identifier or a 'CYCLE' keyword between an
    integer and ','.</p>
  </blockquote>
  
  <p>could you please help what went wrong.</p>
  
  <p>Thanks in advance</p>