About AcharkiMed

AcharkiMed · ‎10-01-2018

Hi, Please try to change all these 3 params: TSaslTransportBufSize=4000; RowsFetchedPerBlock=60536; SSP_BATCH_SIZE=60536;

AcharkiMed · ‎09-29-2018

Hi @Bishnup ConfiguringServer-SideProperties When connecting to a server that is running Impala 2.0 or later, you can use the driver to apply configuration properties to the server by setting the properties in the connection URL. https://www.cloudera.com/documentation/other/connectors/impala-jdbc/latest/Cloudera-JDBC-Driver-for-Impala-Install-Guide.pdf Good luck.

AcharkiMed · ‎07-26-2018

Hi @lonetiger You can do it by two kind of scripts: 1- show all tables: SHOW TABLES; get the list and run this query on all tables: DESCRIBE FORMATTED tableX; Then you can get the results and extract the owner, if it's the desired one, drop the table. 2- Connect with your hive metastore DB and get the table list of the owner you want SELECT "TBL_NAME" FROM "TBLS" WHERE "OWNER" = 'ownerX'; Then drop them. Good luck.

AcharkiMed · ‎07-25-2018

Hi @Tomas79 Check the value of your params SSL= UseSASL= in odbc.ini

AcharkiMed · ‎07-25-2018

Hi @lonetiger What do you mean by table owner ? If you use apache sentry just login to impala-shell by the user concerned (owner) and execute show tables; and you'll see just this user tables Good luck.

AcharkiMed · ‎07-20-2018

HI @Derek Try this workaround: 1- Create new table with the original table's data. 2- Drop all data from old table (using delete). 3- Insert data from new table into old table. 4- Drop new table. Good luck.

AcharkiMed · ‎07-14-2018

Hi @AkhilD Try with this indirect method: SELECT split_part(input, ':', 1)*3600 + split_part(input, ':', 2)*60 + split_part(input, ':', 3) FROM your_table; Good luck.

AcharkiMed · ‎07-11-2018

Hi @Lars Volker Thanks for your reply, Did you mean that I have to create two clusters and synchronise the data between them? if yes wht is the best tool to do this? Peers, DistCp HDFS command or another technic ? What if I do the second rack in different data centers but in same country (US for example), is latency will be reasonable or no!? or the unique solution is to have the two racks in the same data center!! What about Kudu? is it have any rack awareness ? Is there any kind of cloudera documentation about the architechture of multi datacenters/racks.. ? Remark: In fact, I dont now why there is a HA config in all services if there is no rack awareness. Thanks again.

AcharkiMed · ‎07-11-2018

Hi, I'm working on CDH v5.14.2/CM v5.14.1, I was having a cluster with 15 nodes in one rack (/my_cluster/rack1) in a US data center, and the execution time of queries was great (ex. 2.8 secs), when I decide to extand the cluster and takes into account the HA, I add 10 nodes in a europe datacenter and I assign them like a seconde rack (/my_cluster/rack2). The problem is when I start the impala daemons of the 10 new nodes (rack2), the same queries execution time became extremely long (ex. 4.5 min). NB: I realize that one rack must be faster than two separated racks, but in in my case the difference is huge (about x100)!! and what about the rack awareness in hadoop.. Here is the profile files of the query in two cases: 1 rack (15nodes): query profile - 2.8 sec 2 racks (15+10 nodes): query profile - 4.5 min Thanks in advance.

AcharkiMed · ‎06-27-2018

Hi @ni4ni I think the sulotion is to format the RMStateStore : yarn resourcemanager -format-state-store source: https://stackoverflow.com/questions/39369149/resource-manager-does-not-transit-to-active-state-from-standby

Online	Offline
Last Visited	‎05-25-2022 11:41 AM

Member Since	‎07-17-2017 07:15 AM
Last Visited	‎05-25-2022 11:41 AM
Posts	143
Kudos received	16

Cloudera Community

Re: What performance to expect from Cloudera VM ?

Re: Impala date

Re: Error 1107

Re: Cannot connect to Impala via ODBC

Re: Getting improper "Unexpected character" using ...

Re: Impala ODBC/JDBC bad performance - rows fetch ...

Re: Impala ODBC/JDBC bad performance - rows fetch ...

Re: How to show tables based on the table owner?

Re: Cannot connect to Impala via ODBC

Re: How to show tables based on the table owner?

Re: How to rename kudu table name on impala versio...

Re: How to convert hh:mm:ss to seconds in impala?

Re: When I add a new rack some Impala queries beca...

When I add a new rack some Impala queries became e...

Re: Yarn HA does not work (both Resource manager s...