About Saurabhatiyal

Saurabhatiyal · ‎07-24-2024

You can go through below 2 documentation to understand more on Impala Admission Control and how to configure it as per workload : 1. Parameters to set up for admission control https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/impala-manage/topics/impala-admission.html 2. Sample Scenario https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/impala-manage/topics/impala-admission-example.html

Saurabhatiyal · ‎07-23-2024

Hello @Edu7478 This seems to be a common issue faced during high concurrency when there is no control on how much memory a query can utilise. You can check below : - all tables has updated stats - configure / fine tume Impala Admission Control

Saurabhatiyal · ‎04-24-2023

I believe that issue you are facing here is due to column type Geometry When data is present in HDFS , thought is mapped to a Hive Table, particular column must be in STRING which is incompatible with Geometry type column in destination postgres, Only option we have is to alter the column type to VARCHAR at postgres

Saurabhatiyal · ‎04-18-2023

This issue doesn't seems to be driver dependent , but moreover conversion of Geometry data type to Java compatible data type (string could be the best suited for mixed data types) For now you can cast Geometry column to VarChar in a select query and pass the same query in sqoop import command using "--query <sql_query>" tag

Saurabhatiyal · ‎04-17-2023

Check column type for table geom. During runtime sqoop was not able to identify data in column geom causing this issue Workaround : add --map-column-java geom string https://docs.cloudera.com/sqoop/1.4.7.7.1.6.0/user-guide/index.html#_controlling_type_mapping

Online	Offline
Last Visited	‎11-22-2024 05:24 AM

Member Since	‎10-15-2021 06:43 AM
Last Visited	‎11-22-2024 05:24 AM
Posts	89
Kudos received	1

Cloudera Community

Re: IMPALA - MEMORY LIMIT EXEDED

Re: IMPALA - MEMORY LIMIT EXEDED

Re: IMPALA - MEMORY LIMIT EXEDED

Re: Sqoop export to Postgresql with geometry colum...

Re: Sqoop export to Postgresql with geometry colum...

Re: Sqoop export to Postgresql with geometry colum...