Trino Query Error Too many dots in table name
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Damian2023
5 - Atom
‎09-29-2023
01:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello
I am having issues running a query where I'm using a temp table, I cannot find a good source of the answer, if someone came across this scenario and was able to resolve please share.
Labels:
- Labels:
- Documentation
1 REPLY 1
Peachyco
11 - Bolide
‎10-02-2023
05:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is kinda difficult to troubleshoot without getting a good sense of your query. Can you share your query? Maybe change the actual values if you're concerned about security.
We did encounter something like this, and it involved the double-quotes ("") in the name - not specifically in Alteryx but in the query itself:
- Our original query looked something like: SELECT * FROM ABC.XYZ."SOME.TABLE.NAME";
- It turned out that the double-quotes were being discarded by the system during interpretation, ending up with too many dots.
- The solution was to escape the double-quotes: SELECT * FROM ABC.XYZ.\"SOME.TABLE.NAME\";
