MongoDB SQL query for table/collections having hyphens (-) in sql-to-mongo-db-query-converter

Asked Aug 27 '21 at 06:24

Active Aug 27 '21 at 07:48

Viewed 186 times

I have a database and collections which have hyphens (-) in their names.

select * 
from test-schema.test-collection;

I'm using sql-to-mongo-db-query-converter dependency to convert above query to mongoDB but it throwing this exception

Exception Image

I tried using all possible ways like single quotes ('), double quotes (") and punctuation mark (`). It works fine for database if we use below query but it's not working if there is hyphens in collections name.

select * 
from "test-schema".test-collection;

edited Aug 27 '21 at 07:48

asked Aug 27 '21 at 06:24

Abhishek C

You probably want `"test-schema"."test-collection"`. – jarlh Aug 27 '21 at 07:05
@jarlh, Tried it's not working. – Abhishek C Aug 27 '21 at 07:22
I don't think `"` characters work like that unless you have `set quoted_identifier on` in effect. Have you tried square brackets instead, i.e.: `[test-schema].[test-collection]`? – AlwaysLearning Aug 27 '21 at 08:32
@AlwaysLearning, yes, tried but same Exception. – Abhishek C Aug 27 '21 at 10:36
Does this answer your question? [Working with special characters in a Mongo collection](https://stackoverflow.com/questions/9569976/working-with-special-characters-in-a-mongo-collection) – SMor Aug 27 '21 at 10:38
@SMor, No, It's different issue. – Abhishek C Aug 27 '21 at 11:14

MongoDB SQL query for table/collections having hyphens (-) in sql-to-mongo-db-query-converter

0 Answers0