Hi Chris,
It is strongly recommended not to create table names beginning with numbers in mongo. Although mongo supports this, it can become very complex in ANSI SQL. > On May 26, 2022, at 17:16, spamo...@freenet.de wrote: > > Hello, > > I've got a few Mongo collections and would like to use: > 01_test > > apache drill (mongo.crm_test)> SHOW DATABASES; > +--------------------+ > | SCHEMA_NAME | > +--------------------+ > | mongo.01_test | > | mongo.test | > > apache drill (mongo.crm_test)> usemongo.test; > +------+--------------------------------------------+ > | ok | summary | > +------+--------------------------------------------+ > | true| Default schema changed to [mongo.test]| > +------+--------------------------------------------+ > > But: > > apache drill (mongo.test)> usemongo.01_test; > Error: PARSE ERROR: Encountered ".01" at line 1, column 10. > > SQL Query: use mongo.01_test > ^ > > [Error Id: 056ff092-822b-4113-bf06-27e960cfe69a ] (state=,code=0) > > > I've tried it with " and ' but nothing seems to be working for > a collection, starting with a number. > How to do this? > > Thanks and kind regards, > Chris