Member since
07-30-2019
333
Posts
357
Kudos Received
76
Solutions
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 11680 | 02-17-2017 10:58 PM | |
| 3182 | 02-16-2017 07:55 PM | |
| 9421 | 12-21-2016 06:24 PM | |
| 2373 | 12-20-2016 01:29 PM | |
| 1659 | 12-16-2016 01:21 PM |
01-20-2016
08:02 PM
1 Kudo
Vlad, at this point please go into NiFi's bin directory and execute nifi.sh dump command. Send those logs through.
... View more
01-06-2016
03:48 PM
Some queries won't engage CBO, simply because there's nothing for it to optimize in a plan. Are you observing slow performance?
... View more
01-06-2016
12:10 AM
10000 is not an adequate setting. Please update your system config as outlined here http://nifi.apache.org/quickstart.html
... View more
01-05-2016
05:56 PM
1 Kudo
In recent HDP versions you don't have to explicitly enable it, it should be on by default already. You can check via Ambari -> Hive -> Configs. It will have the CBO switch like below:
... View more
01-05-2016
04:46 PM
I found that to_date() function generates correct data types which will work correctly with comparisons and ordering.
... View more
01-05-2016
02:42 PM
1 Kudo
Through experiments I found this one works as expected: jdbc:hive2://> select date_sub(current_timestamp(), 0);
OK
+-------------+--+
| _c0 |
+-------------+--+
| 2016-01-05 |
+-------------+--+
Which is much harder than it should be. Given how much legacy SQL there is relying on trunc(timestamp), can we enhance the Hive's function to throw the timestamp out too maybe?
... View more
01-05-2016
02:33 PM
Are you using the latest sandbox? Try the Ambari Hive view, it has the Upload File action specifically for csv files.
... View more
01-05-2016
02:32 PM
From the https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions trunc(string date, string format) I'm executing these commands in beeline: 0: jdbc:hive2://> select trunc(current_timestamp(), 'MM');
OK
+-------------+--+
| _c0 |
+-------------+--+
| 2016-01-01 |
+-------------+--+
1 row selected (0.97 seconds)
0: jdbc:hive2://> select trunc(current_timestamp(), 'DD');
OK
+-------+--+
| _c0 |
+-------+--+
| NULL |
+-------+--+
1 row selected (0.241 seconds)
Now, the question is why doesn't it support a day value? This is such a natural function for truncating timestamps to a day only.
... View more
Labels:
- Labels:
-
Apache Hive
01-04-2016
02:18 PM
As a tip - one can put a service into a Maintenance mode (check out the service actions menu when you go to a service screen). This will suppress alerts and also make this service ignore bulk action requests (like restart all).
... View more
01-04-2016
02:11 PM
1 Kudo
Peter, the intent is not to start every single service in the sandbox VM - it will get very memory-heavy quickly. I'm not even sure 8GB would be a comfortable setting. In addition, because it's a VM which will be suspended and resumed often, some services will complain and raise alerts due to a clock drift (e.g. HBase is notorious for that). All-in-all, that shouldn't be an issue. I would, however, check with core services states first. Is Ambari Metrics service running?
... View more