About APentyala

APentyala · ‎04-21-2025

Hi All, I’ve created a .hql file containing multiple INSERT statements for Hive tables and I'm calling the script using Beeline. I need help with capturing error codes in a log file. Also, if any INSERT statement fails, I want the continue the remaining statements and need to be write a log into file. I am using below command but it is writing more details log > archive_$(date +\%Y\%m\%d).log 2>&1' Please advise how to handle this?

APentyala · ‎03-16-2025

Dear all, In this post, the Impala driver was installed, but the DSN was created using Hive drivers. Can you confirm whether Impala drivers cannot be used to create an ODBC DSN and if Power BI does not support it as ODBC?

APentyala · ‎02-03-2025

Any inputs?

APentyala · ‎01-26-2025

Hi Team, I’m seeking your support in converting a string to a timestamp with microseconds in Hive. When using unixtimestamp, I notice that the milliseconds are being dropped. Could you please advise on how to capture milliseconds (and microseconds) correctly, and which data type I should use to store the value in Hive? SELECT from_unixtime(unix_timestamp('2024-11-05-10.03.17.872195', 'yyyy-MM-dd-HH.mm.ss.SSSSSS')) as times,'2024-11-05-10.03.17.872195' as vale FROM

APentyala · ‎08-19-2024

Yes, using HDFS to store, is there any limitation?

APentyala · ‎08-18-2024

Hi @asish Thank you for your answers. Could you please provide more details on the following 1. Data Modeling Design: Which model is best suited for a Lakehouse implementation, star schema or snowflake schema? 2. We are using CDP (Private) and need to implement updates and deletes (SCD Type 1 & 2). Are there any limitations with Hive external tables? 3. Are there any pre-built dimension models or ER models available for reference?

APentyala · ‎08-14-2024

Hello Everyone, We are developing a data lakehouse using Hive for the banking and financial sector. We would appreciate your insights on the following: 1. Which data modeling approach is recommended for this domain? 2. Are there any sample models available for reference? 3. What best practices should we follow to ensure data integrity and performance? 4. How can we efficiently manage large-scale data ingestion and processing? 5. Are there any specific challenges or pitfalls we should be aware of when implementing a lakehouse in this sector? Your expertise and guidance would be greatly appreciated.

Online	Offline
Last Visited	‎06-05-2025 07:10 AM

Member Since	‎07-15-2024 05:21 AM
Last Visited	‎06-05-2025 07:10 AM
Posts	7
Kudos received	2

Cloudera Community

hql Script Error Handling in Beeline Execution

Re: How to Connect to Impala Using the Power BI De...

Re: Sting to Timestamp (6) in Hive

Sting to Timestamp (6) in Hive

Re: Data Wareshouse design in Hive

Re: Data Wareshouse design in Hive

Data Wareshouse design in Hive