Failed to recognize predicate 'ARRAY'. Failed rule: 'identifier' in table or column identifier
Open
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 906
- Forks
- 219
- Avg merge
- 2d 13h
- Merged PRs (30d)
- 2
Description
I am having a problem with sql translation to Trino that results in a query with an identifier column.
SELECT numbers , animal , n , a
FROM (
VALUES
( ARRAY [ 2 , 5 ], ARRAY [ 'dog' , 'cat' , 'bird' ]),
( ARRAY [ 7 , 8 , 9 ], ARRAY [ 'cow' , 'pig' ])
) AS x ( numbers , animals )
CROSS JOIN UNNEST ( numbers, 动物) AS t ( n , a );
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the supplied SQL translation to Trino and isolate the parser failure around ARRAY and identifier handling. Compare the reported error with the query structure; done means this query translates successfully without the failed 'identifier' rule.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100