Json Parsing error when using Formula In DB tool

[NehaAhujaGrab]

I am running into below error while using Formula In DB tool. Could anyone help decode this error for me? I am trying to create a calculated column using the formula tool.

Error: Formula In-DB (9): Error SQLPrepare: [Simba][Trino] (1050) JSON parsing error: errorCode member not found..

[danilang]

Hi @NehaAhujaGrab 

You've got "hive"."crm"."test".* within your select statement.  This is returning the entire row, which can't be assigned to a double variable.   Remove this and the remaining ..."total_spend"/..."event_count" should execute correctly 

Dan

[apathetichell]

Following up on @danilang 's statement - you would not use a select/from syntax in a formula in-db. You are choosing a specific field in your formula-in-db config - so it's effectively already saying SELECT. Your from is set in other In-DB tools - not in your formula In-DB (I've never used a query to create a value there but my hunch is there are better ways to do this - even if it's supported - which I don't think it is). Your Formula-In-DB is JUST YOUR FORMULA.

And by specifying that you are using this formula on field CPE - you don't need an AS statement.