Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
118
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.47 KB | None | 0 0
  1. dataset.write()
  2. .mode(SaveMode.Overwrite)
  3. .format(FORMAT_IGNITE())
  4. .option(OPTION_CONFIG_FILE(), "ignite-server-config.xml")
  5. .option(OPTION_TABLE(), "CUSTOM_VALUES")
  6. .option(OPTION_CREATE_TABLE_PRIMARY_KEY_FIELDS(), "ID")
  7. .save();
  8.  
  9. Column id = igniteDataset.col("ID");
  10. Column customized_id = igniteDataset.col("CUSTOMIZED_ID");
  11. Column fid = igniteDataset.col("CUSTOM_FIELD_ID");
  12. Column type = igniteDataset.col("CUSTOMIZED_TYPE");
  13. Column val = igniteDataset.col("VALUE");
  14.  
  15. RelationalGroupedDataset idGroupedData = igniteDataset.groupBy(customized_id);
  16.  
  17. Dataset<Row> result = idGroupedData.agg(count(id).as("count_id"),
  18. count(fid).as("count_custom_field_id"),
  19. count(type).as("count_customized_type"),
  20. count(val).as("count_value"), count(customized_id).as("groupCount"));
  21.  
  22. Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "SELECT COUNT(1) AS COUNT FROM (SELECT FROM CUSTOM_VALUES GROUP[*] BY CUSTOMIZED_ID) TABLE1 "; expected "., (, USE, AS, RIGHT, LEFT, FULL, INNER, JOIN, CROSS, NATURAL, ,, SELECT"; SQL statement:
  23. SELECT COUNT(1) AS count FROM (SELECT FROM CUSTOM_VALUES GROUP BY CUSTOMIZED_ID) table1 [42001-197]
  24. at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
  25. at org.h2.message.DbException.getSyntaxError(DbException.java:217)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement