Cloudera Community
Saurabhatiyal
user rank
user rank
Contributor
My Accepted Solutions
Show All

Re: IMPALA - MEMORY LIMIT EXEDED

by Contributor Contributor in Support Questions
‎07-24-2024 12:19 AM
1 Kudo
‎07-24-2024 12:19 AM
1 Kudo
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 ... View more

Re: IMPALA - MEMORY LIMIT EXEDED

by Contributor Contributor in Support Questions
‎07-23-2024 12:21 PM
‎07-23-2024 12:21 PM
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 ... View more

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

by Contributor Contributor in Support Questions
‎04-24-2023 01:22 AM
‎04-24-2023 01:22 AM
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 ... View more

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

by Contributor Contributor in Support Questions
‎04-18-2023 02:12 AM
‎04-18-2023 02:12 AM
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  ... View more

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

by Contributor Contributor in Support Questions
‎04-17-2023 03:04 AM
‎04-17-2023 03:04 AM
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 ... View more
Contact Me
Online
Offline
Last Visited
‎12-25-2024 10:28 AM
Community Statistics
Member Since ‎10-15-2021 06:43 AM
Last Visited ‎12-25-2024 10:28 AM
Posts 89
Kudos received 1