Input data is this:
➜ bin cat test.json
{
"hr" : {
"employees": [
{ "id": 3, "name": "Bob Smith", "title": null },
{ "id": 4, "name": "Susan Smith", "title": "Dev Mgr" },
{ "id": 6, "name": "Jane Smith", "title": "Software Eng 2"}
]
}
}
If I run with following command:
./partiql -i test.json -q "select * from hr.employees;"
I get this error
➜ bin ./partiql -i test.json -q "select * from hr.employees;"
org.partiql.lang.eval.EvaluationException: No such binding: hr.
Evaluator Error: at line 1, column 15: Binding 'hr' does not exist
at org.partiql.lang.eval.EvaluatingCompiler$compileVariableReference$$inlined$thunkEnv$lang$1$1.invoke(Thunk.kt:726)
at org.partiql.lang.eval.EvaluatingCompiler$compileVariableReference$$inlined$thunkEnv$lang$1$1.invoke(Thunk.kt:128)
at org.partiql.lang.eval.LegacyThunkFactory.handleException(Thunk.kt:527)
at org.partiql.lang.eval.EvaluatingCompiler$compileVariableReference$$inlined$thunkEnv$lang$1.invoke(Thunk.kt:209)
at org.partiql.lang.eval.EvaluatingCompiler$compileVariableReference$$inlined$thunkEnv$lang$1.invoke(Thunk.kt:128)
at org.partiql.lang.eval.EvaluatingCompiler$compilePath$$inlined$thunkEnv$lang$1$1.invoke(Thunk.kt:706)
at org.partiql.lang.eval.EvaluatingCompiler$compilePath$$inlined$thunkEnv$lang$1$1.invoke(Thunk.kt:128)
at org.partiql.lang.eval.LegacyThunkFactory.handleException(Thunk.kt:527)
at org.partiql.lang.eval.EvaluatingCompiler$compilePath$$inlined$thunkEnv$lang$1.invoke(Thunk.kt:209)
at org.partiql.lang.eval.EvaluatingCompiler$compilePath$$inlined$thunkEnv$lang$1.invoke(Thunk.kt:128)
at org.partiql.lang.eval.EvaluatingCompiler$compileQueryWithoutProjection$1$$special$$inlined$foldLeftProduct$1.iterator(CollectionExtensions.kt:236)
at kotlin.collections.CollectionsKt___CollectionsKt$asSequence$$inlined$Sequence$1.iterator(Sequences.kt:681)
at kotlin.sequences.TransformingSequence$iterator$1.<init>(Sequences.kt:208)
at kotlin.sequences.TransformingSequence.iterator(Sequences.kt:207)
at kotlin.sequences.TransformingSequence$iterator$1.<init>(Sequences.kt:208)
at kotlin.sequences.TransformingSequence.iterator(Sequences.kt:207)
at kotlin.sequences.TransformingSequence$iterator$1.<init>(Sequences.kt:208)
at kotlin.sequences.TransformingSequence.iterator(Sequences.kt:207)
at org.partiql.lang.eval.SequenceExprValue.iterator(ExprValueFactory.kt:537)
at org.partiql.lang.util.ConfigurableExprValueFormatter$PrettyFormatter.prettyPrintContainer(ExprValueFormatter.kt:68)
at org.partiql.lang.util.ConfigurableExprValueFormatter$PrettyFormatter.prettyPrintContainer$default(ExprValueFormatter.kt:66)
at org.partiql.lang.util.ConfigurableExprValueFormatter$PrettyFormatter.recursivePrettyPrint(ExprValueFormatter.kt:54)
at org.partiql.lang.util.ConfigurableExprValueFormatter.formatTo(ExprValueFormatter.kt:32)
at org.partiql.lang.util.ExprValueFormatter$DefaultImpls.format(ExprValueFormatter.kt:15)
at org.partiql.lang.util.ConfigurableExprValueFormatter.format(ExprValueFormatter.kt:20)
at org.partiql.lang.eval.ExprValueExtensionsKt.stringify(ExprValueExtensions.kt:165)
at org.partiql.lang.eval.BaseExprValue.toString(BaseExprValue.kt:45)
at org.partiql.cli.Cli.run(Cli.kt:65)
at org.partiql.cli.Main.runCli(main.kt:189)
at org.partiql.cli.Main.main(main.kt:147)
What’s wrong?