Query executed error

Problem

Query executed error on TigerGraph v3.6 with the message "no type can be inferred for field name>"

Error message

ERROR.20220628-032553.598:

E@20220628 03:30:58.333 tigergraph|127.0.0.1:38926|00000000024 (CodeCheckHandler.java:72) com.tigergraph.engine.util.a.d:
Type Check Error in query AllSubscriberScore (TYP-8017): line 12, col 30
no type can be inferred for e.hourly_user_video_experience_score
com.tigergraph.engine.util.a.d:
Type Check Error in query AllSubscriberScore (TYP-8017): line 12, col 30
no type can be inferred for e.hourly_user_video_experience_score

Diagnosis

Applied logic confusion

Workaround

Use the case when syntax to judge each condition individually

Solution

Sample query:

sample_query