Issue with SHOW FULL TABLES FROM hive.cvm in Doris

2023-10-05 Thread Joice Jacob
Dear Doris Community, I am writing to seek assistance with an issue I've encountered when working with Doris involving catalog and database names. In my doris setup, there is an internal catalog containing a database named "*demo*," and an external catalog named "*hive*" with a database named " *

Re: Issue with SHOW FULL TABLES FROM hive.cvm in Doris

2023-10-05 Thread Guangdong Liu
Try this *SHOW FULL TABLES FROM `hive:cvm`;* -- Best Regards Liugddx liug...@gmail.com Joice Jacob 于2023年10月5日周四 16:52写道: > Dear Doris Community, > > I am writing to seek assistance with an issue I've encountered when > working with Doris involving catalog and database names. >

Re: Issue Integrating Hive on CDP Distribution with Doris 2.0.1.1

2023-10-05 Thread Guangdong Liu
Can you see the detailed information of the table baby? `DESCRIBE FORMATTED baby;` -- Best Regards Liugddx liug...@gmail.com Joice Jacob 于2023年10月5日周四 13:30写道: > Dear Doris Community & Jiafeng.Zhang > , > Thank you for your prompt response and your willingness to assist with t

Re:[VOTE] Release Apache Doris-Shade 1.0.2

2023-10-05 Thread Mingyu Chen
Hi Wudi: I see that the change log[1] is modified 4 month ago, is that correct? [1] https://github.com/apache/doris-shade/blob/doris-shade-1.0.2/CHANGE-LOG.txt -- Best Regards Mingyu Chen Email: morning...@apache.org At 2023-09-28 15:23:45, "wudi" <676366...@qq.com.INVALID> wrote: >Hi

Re:Re: Spotless - code formatting tool

2023-10-05 Thread Mingyu Chen
Hi Liu: This PR is too large and may be conflict with so many other PRs. Is there any way to just modify the incremental code, not existing code? -- Best Regards Mingyu Chen Email: morning...@apache.org At 2023-10-01 17:28:53, "Guangdong Liu" wrote: >Hi dev > >This is my PR, please help

Re:Issue with SHOW FULL TABLES FROM hive.cvm in Doris

2023-10-05 Thread Mingyu Chen
Hi Joice, You may try add this in fe.conf, and restart FE and try again: infodb_support_ext_catalog=true -- Best Regards Mingyu Chen Email: morning...@apache.org At 2023-10-05 16:52:15, "Joice Jacob" wrote: Dear Doris Community, I am writing to seek assistance with an issue I've enco

Re:Re: Issue Integrating Hive on CDP Distribution with Doris 2.0.1.1

2023-10-05 Thread Mingyu Chen
I saw that your hive table is with property "transactional" = "true", And Doris only support ACID table with Hive 3, not support with Hive 2.x. So you may need to create non-transactional hive table for Doris to visit. -- Best Regards Mingyu Chen Email: morning...@apache.org 在 2023-10-05

Re: Issue Integrating Hive on CDP Distribution with Doris 2.0.1.1

2023-10-05 Thread Joice Jacob
Hi Guangdong Liu, please find the attachment for DESCRIBE FORMATTED baby output On Thu, Oct 5, 2023 at 6:27 PM Guangdong Liu wrote: > Can you see the detailed information of the table baby? > > `DESCRIBE FORMATTED baby;` > > -- > > Best Regards > > > > Liugddx > liug...@gmail.com >

Re: Re: Issue Integrating Hive on CDP Distribution with Doris 2.0.1.1

2023-10-05 Thread Joice Jacob
Hi, I wanted to share some important information regarding the CDP Hive version that I am currently using, which is Hive 3.1.3000.7.1.7.0-551. In CDP Hive version 3.x, a significant change has been introduced regarding managed tables. By default, managed tables in Hive 3.x are considered transacti

Re: Issue with SHOW FULL TABLES FROM hive.cvm in Doris

2023-10-05 Thread Joice Jacob
Hi, Thank you for the suggestion and for trying to help resolve the issue. I appreciate your assistance in troubleshooting the problem. I followed your recommendation and added the configuration infodb_support_ext_catalog=true to the fe.conf file. However, after restarting the Frontend (FE), the i

Re:Re: [VOTE] Release Apache Doris 2.0.2

2023-10-05 Thread Mingyu Chen
Here is my + 1 I checked [x] The download link is legal. [x] The PGP signature are valid. [x] The source code matches the current release version. [x] The LICENSE and NOTICE files are correct. [x] All files carry the necessary protocol header. [x] The compiled content is not included in the sourc

Re:Re: Issue with SHOW FULL TABLES FROM hive.cvm in Doris

2023-10-05 Thread Mingyu Chen
That is strange, I test it in my own env and it works: mysql> show full tables from hive.tpch100_orc; +---++---+ | Tables_in_tpch100_orc | Table_type | StorageFormat | +---++---+ | cust

Re:Re: Re: Issue Integrating Hive on CDP Distribution with Doris 2.0.1.1

2023-10-05 Thread Mingyu Chen
Oh, I see, let me check it again. -- Best Regards Mingyu Chen Email: morning...@apache.org At 2023-10-05 21:49:28, "Joice Jacob" wrote: >Hi, >I wanted to share some important information regarding the CDP Hive version >that I am currently using, which is Hive 3.1.3000.7.1.7.0-551. > >In

Re: Re: Issue with SHOW FULL TABLES FROM hive.cvm in Doris

2023-10-05 Thread Guangdong Liu
I tried it. If I use ":", I can query the results. If I use "," ,it will fail [image: image.png] and I found that the problem may lie here, the obtained dbname does not remove the catalog name. I'm not sure if it's a problem. [image: image.png] -- Best Regards Liugddx liug...@gm

Re: Re: Issue with SHOW FULL TABLES FROM hive.cvm in Doris

2023-10-05 Thread Joice Jacob
Hi Mingyu Chen, I wanted to share an exciting development regarding our project to integrate Apache Calcite with Hive Catalog in Doris. Our primary goal is to leverage the capabilities of the* Apache Calcite* framework to seamlessly access and process metadata about tables and columns in our Doris

Error Encountered While Executing SHOW FULL COLUMNS in Doris with Hive Catalog

2023-10-05 Thread Joice Jacob
Dear Doris Community, I am writing to seek assistance with an issue I encountered while working with Doris and the Hive catalog. My goal was to execute the following SQL statement: *SHOW FULL COLUMNS FROM hive.cvm.instant_cdr;*However, when I attempted to run this query, I received the following

Re: Re: Spotless - code formatting tool

2023-10-05 Thread Guangdong Liu
I agree with you. I've modified it, using https://github.com/diffplug/spotless/tree/main/plugin-maven#how-can-i-enforce-formatting-gradually-aka-ratchet -- Best Regards Liugddx liug...@gmail.com Mingyu Chen 于2023年10月5日周四 21:25写道: > Hi Liu: > This PR is too large and may be con