Cloudera Community
BennyZ
user rank
user rank
Expert Contributor

Re: Insert into Iceberg with TEZ works on CDP but ...

by Expert Contributor Expert Contributor in Support Questions
‎07-21-2023 03:14 AM
‎07-21-2023 03:14 AM
Hi, You can try to use CDP public cloud 7.2.17 which officially supports iceberg on Hive. https://docs.cloudera.com/runtime/7.2.17/iceberg-overview/topics/iceberg-overview.html   ... View more

Re: queries taking forever upgrading to hive-on-te...

by Expert Contributor Expert Contributor in Support Questions
‎05-16-2022 11:59 PM
‎05-16-2022 11:59 PM
Hi Djentlguy,   It is hard to say what is the actual issue we are hitting. We have to look into the Hive/App logs.  Could you open a Cloudera support case to report this issue?  ... View more

Re: Slow query in Hive

by Expert Contributor Expert Contributor in Support Questions
‎02-17-2022 01:17 AM
1 Kudo
‎02-17-2022 01:17 AM
1 Kudo
Reported this issue to Cloudera support case.  ... View more

Re: upto what level of dot notations can be tried ...

by Expert Contributor Expert Contributor in Support Questions
‎11-09-2021 11:03 PM
‎11-09-2021 11:03 PM
Hope the below document can answer your question.    https://impala.apache.org/docs/build/html/topics/impala_struct.html   It looks like we have to change the query as below: select abc, def, b1.c1 from xxx, xxx.a1 where so n so ... View more

Re: SQL statement to capitalize the first letter

by Expert Contributor Expert Contributor in Support Questions
‎11-05-2021 06:34 AM
‎11-05-2021 06:34 AM
@Sam7 please try : select concat(UPPER(SUBSTRING(fieldname,1,2)),LOWER(SUBSTRING(fieldname,3,LENGTH(fieldname)))) AS fieldname from ...   You can check the below document for the usage of substring() https://cwiki.apache.org/confluence/display/hive/languagemanual+udf ... View more

Re: How to send data from Hive(which is stored on ...

by Expert Contributor Expert Contributor in Support Questions
‎10-28-2021 01:14 AM
‎10-28-2021 01:14 AM
Hive doesn't provide the rest API itself. The user has to connect Hive by using JDBC/ODBC to fetch the data. Alternatively, you may write the query result to the ADLS and fetch the data via ADLS rest API. https://docs.qubole.com/en/latest/user-guide/engines/presto/insert.html ... View more

Re: SQL statement to capitalize the first letter

by Expert Contributor Expert Contributor in Support Questions
‎10-18-2021 06:06 AM
1 Kudo
‎10-18-2021 06:06 AM
1 Kudo
With hive query,  please try    select concat(UPPER(SUBSTRING(fieldname,1,1)),LOWER(SUBSTRING(fieldname,2,LENGTH(fieldname)))) AS fieldname from ... ... View more
Contact Me
Online
Offline
Last Visited
‎10-25-2024 01:27 AM
Community Statistics
Member Since ‎08-16-2017 10:14 PM
Last Visited ‎10-25-2024 01:27 AM
Posts 188
Kudos received 2