Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- dataset.write()
- .mode(SaveMode.Overwrite)
- .format(FORMAT_IGNITE())
- .option(OPTION_CONFIG_FILE(), "ignite-server-config.xml")
- .option(OPTION_TABLE(), "CUSTOM_VALUES")
- .option(OPTION_CREATE_TABLE_PRIMARY_KEY_FIELDS(), "ID")
- .save();
- Column id = igniteDataset.col("ID");
- Column customized_id = igniteDataset.col("CUSTOMIZED_ID");
- Column fid = igniteDataset.col("CUSTOM_FIELD_ID");
- Column type = igniteDataset.col("CUSTOMIZED_TYPE");
- Column val = igniteDataset.col("VALUE");
- RelationalGroupedDataset idGroupedData = igniteDataset.groupBy(customized_id);
- Dataset<Row> result = idGroupedData.agg(count(id).as("count_id"),
- count(fid).as("count_custom_field_id"),
- count(type).as("count_customized_type"),
- count(val).as("count_value"), count(customized_id).as("groupCount"));
- 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:
- SELECT COUNT(1) AS count FROM (SELECT FROM CUSTOM_VALUES GROUP BY CUSTOMIZED_ID) table1 [42001-197]
- at org.h2.message.DbException.getJdbcSQLException(DbException.java:357)
- at org.h2.message.DbException.getSyntaxError(DbException.java:217)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement