Re: Creating TemporalTable based on Catalog table in SQL Client

2020-03-04 Thread Bowen Li
you would need to reference the table with fully qualified name with catalog and database On Wed, Mar 4, 2020 at 02:17 Gyula Fóra wrote: > I guess it will only work now if you specify the catalog name too when > referencing the table. > > > On Wed, Mar 4, 2020 at 11:15 AM Gyula Fóra wrote: > >

Re: Creating TemporalTable based on Catalog table in SQL Client

2020-03-04 Thread Gyula Fóra
I guess it will only work now if you specify the catalog name too when referencing the table. On Wed, Mar 4, 2020 at 11:15 AM Gyula Fóra wrote: > You are right but still if the default catalog is something else and > that's the one containing the table then it still wont work currently. > > Gyu

Re: Creating TemporalTable based on Catalog table in SQL Client

2020-03-04 Thread Gyula Fóra
You are right but still if the default catalog is something else and that's the one containing the table then it still wont work currently. Gyula On Wed, Mar 4, 2020 at 5:08 AM Bowen Li wrote: > Hi Gyula, > > What line 622 (the link you shared) does is not registering catalogs, but > setting an

Re: Creating TemporalTable based on Catalog table in SQL Client

2020-03-03 Thread Bowen Li
Hi Gyula, What line 622 (the link you shared) does is not registering catalogs, but setting an already registered catalog as the current one. As you can see from the method and its comment, catalogs are loaded first before any tables in yaml are registered, so you should be able to achieve what yo

Creating TemporalTable based on Catalog table in SQL Client

2020-03-03 Thread Gyula Fóra
Hi all! I was testing the TemporalTable functionality in the SQL client while using the Hive Catalog and I ran into the following problem. I have a table created in the Hive catalog and I want to create a temporal table over it. As we cannot create temporal tables in SQL directly I have to defin