imem
imem copied to clipboard
DDMonitor CSV download fails

14:23:43.839 [error] [_DDRL_] {imem_adapter,667} query error
{{'ClientError',{"Ambiguous field or table name",<<"node">>}},
[{imem_sql_expr,'-field_map_lookup/2-fun-18-',1,[{file,"src/imem_sql_expr.erl"},{line,810}]},
{imem_sql_expr,column_map_columns,3,[{file,"src/imem_sql_expr.erl"},{line,742}]},
{imem_sql_expr,column_map_columns,2,[{file,"src/imem_sql_expr.erl"},{line,696}]},
{imem_sql_select,exec,5,[{file,"src/imem_sql_select.erl"},{line,34}]},
{imem_server,mfa,2,[{file,"src/imem_server.erl"},{line,184}]},
{erlimem_cmds,exec_catch,4,[{file,"src/erlimem_cmds.erl"},{line,40}]},
{erlimem_session,handle_call,3,[{file,"src/erlimem_session.erl"},{line,227}]},
{gen_server,try_handle_call,4,[{file,"gen_server.erl"},{line,615}]}]}

ddMonitor table contains node as a column. node is reserved meta column name. This is the reason for the error. As a workaround in the query change node to "node". This will not treat it as a meta field.
This same workaround can be used for log tables as well.