Member since
12-07-2015
83
Posts
23
Kudos Received
10
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2967 | 07-11-2018 02:42 PM | |
7962 | 12-10-2017 08:26 PM | |
2240 | 11-14-2017 12:17 PM | |
16368 | 03-29-2017 06:42 AM | |
2197 | 02-22-2017 01:43 PM |
04-04-2017
04:32 AM
1 Kudo
Hi Alon, Have you tried the inc_stats_size_limit_bytes command line flag as suggested by Tim? It is supported on CDH5.10.0. Here's the full help text from impalad: -inc_stats_size_limit_bytes (Maximum size of incremental stats the catalog is allowed to serialize per table. This limit is set as a safety check, to prevent the JVM from hitting a maximum array limit of 1GB (or OOM) while building the thrift objects to send to impalads. By default, it's set to 200MB) type: int64 default: 209715200 This should allow you to increase the limit you are hitting. Cheers, Lars
... View more
04-04-2017
03:37 AM
Thank you for catching this Tim! The "SORTBY()" hint was added in IMPALA-4163, which was not included in Impala 2.8.0. It is currently being reworked into a SQL clause (IMPALA-4166), so I cannot make promises as to which release will contain this feature. My apologies for the confusion. I will make sure the documentation gets updated.
... View more
04-01-2017
05:30 AM
2 Kudos
Hi imad87, What is the purpose of specifying "ROW FORMAT DELIMITED" without a delimiter character? On first glance it looks like your data file contains the substring "\N" (the \ character followed by the N character) to delimit lines, instead of the "\n" character (ASCII 0xA). Can you double check the file in a hex editor? Cheers, Lars
... View more
03-29-2017
06:42 AM
Hi Amit, Your first question has already been discussed in this thread: There's a bit of a story there. When we started preparing the 5.10 CDH release, the Apache 2.8 Impala release was not ready, so we had to call it "Impala 2.7" in the version number. Impala 2.8 was officially released after we finished putting together the CDH5.10 release - too late to bump the version in all places. CDH5.10 Impala is almost exactly the same as 2.8, plus or minus a few patches, so in most of the announcements we've just called it 2.8. You can find a full list of commits in CDH5.10.0 here: https://github.com/cloudera/Impala/commits/cdh5-2.7.0_5.10.0 The full list of commits in Impala 2.8 are here: https://github.com/apache/incubator-impala/commits/branch-2.8.0 To your second question: Impala does indeed not support the DELETE command for non-Kudu tables. You can use the TRUNCATE command to completely delete all data in a table. Cheers, Lars
... View more
03-27-2017
04:24 AM
Cool, I'm glad you found an answer. Thanks for sharing it here, too. Cheers, Lars
... View more
03-27-2017
04:17 AM
Hi lara105, It certainly should print out a better error message than "null". What version of the JDBC driver are you using Cheers, Lars
... View more
03-03-2017
12:15 PM
1 Kudo
Hi Lennond, can you post the profiles for both queries? Thanks, Lars
... View more
02-28-2017
02:35 PM
Your version of the driver seems to be 2.5.5. The current version is 2.5.36 and can be found here: http://www.cloudera.com/downloads/connectors/impala/jdbc/2-5-36.html Please try again with the latest version and see if that help. The UID parameter should be supported there.
... View more
02-28-2017
01:47 PM
Hi Fawze, That version should have been downloaded from Cloudera and as such the downloaded file comes with its own version number. The current version is 2.5.36. "ImpalaJDBC4.jar" is the name of the file, not the version. What is the connection string you used? What was the error you received? Thanks, Lars
... View more
02-22-2017
01:43 PM
I just saw this thread after commenting on the Jira. Would "conv()" be a suitable workaround here? select conv('100010', 2, 10);
+-----------------------+
| conv('100010', 2, 10) |
+-----------------------+
| 34 |
+-----------------------+
Fetched 1 row(s) in 0.24s More information on conv() can be found in the Impala documentation. Edit: To make things complete, the Jira is IMPALA-4968.
... View more