Member since
09-10-2015
54
Posts
24
Kudos Received
4
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2193 | 10-20-2016 07:44 PM | |
6856 | 10-16-2016 03:14 PM | |
2490 | 05-11-2016 02:16 PM | |
1752 | 09-29-2015 08:27 PM |
05-06-2016
04:26 PM
2 Kudos
There are multiple options: 1. You can use apache tika (using a programming language like Java) to read the xlxs and load into hive. 2. If its a single xls sheet, then you can use pig's CSVExcelStorage() and insert into hive table using HCatStorer() 3. Convert to a delimited CSV and load it.
... View more
04-07-2016
08:27 PM
Thanks @Kuldeep Kulkarni
... View more
04-07-2016
08:04 PM
1 Kudo
Does hiveserver2 JDBC calls support TLSv1.2 ? We are having external applications configured to use TLS1.2 for stronger security.
... View more
Labels:
- Labels:
-
Apache Hive
02-15-2016
04:43 PM
If you are using EC2, then make sure your OS has the properly defined hostnames. You can updated it using hostnamectl or set it on the sysconfig/network files based on your OS version. Then to fix your hostnames in your server/agent, follow: https://ambari.apache.org/1.2.3/installing-hadoop-using-ambari/content/ambari-chap7a.html Restart Ambari Server and Agent and you should be good !
... View more
02-15-2016
04:32 PM
1 Kudo
You don't to STORE the relationship into 'F'. Just issue the store command. Also, please describe 'E' and see the list of column name that you are storing into the hive table. Make sure the column names align and mentioned in lower case in your relationship. If you don't see the field name in the relationship, then you can define one as follows: F = FOREACH E GENERATE (chararray)$0 as (col1:chararray), (chararray)$1 as (col2:chararray), .... etc... and STORE F INTO 'journey_pig' using HCatStorer(); Hope this helps! Thanks!
... View more
01-07-2016
05:52 PM
Thank you very much @zblanco. It worked perfectly fine. Also thank you very much for the reference API.
... View more
01-07-2016
04:00 PM
we are using Ambari alerts Rest API to poll for components health. We would like to filter out the ones which are in Maintenance mode. Any idea what how we can get that. The REST API call throws all the services that are critical- http://<ambari host>:8080/api/v1/clusters/tech_hdp/alerts?Alert/state=CRITICAL
... View more
Labels:
- Labels:
-
Apache Ambari
11-03-2015
03:07 AM
Thanks Deepesh. I'm working with a customer where they have coded the existing Informatica Workflows (BDE) with TRIM on Decimal value in prod. When we are trying to migrate HDP and run them on Hive 0.14, it started erroring out in lower environment. We stated Hive is working as intended to, but wanted to check if there are any workarounds. Thanks!
... View more
11-02-2015
11:08 PM
I'm working on a scenario where a good number of queries uses TRIM(DECIMAL VALUE) in Hive 0.11 (Pivotal 1.0). After migration to HDP 2.2 (Hive 0.14), the queries started failing with error "Trim Takes only STRING/CHAR/VARCHAR types. Found Decimal". If I tried to run the same query as TRIM(STRING(DECIMAL VALUE)), it runs fine in Hive 0.14. Due to the volume of queries that should under go this casting change, is it possible to set this Implicit casting at a global level (say SET). Are there any workaround to trim decimal values in Hive 0.14 (which was supported in 0.11). Thank you!
... View more
Labels:
- Labels:
-
Apache Hive
10-06-2015
04:13 PM
I faced similar issues and asked the same questions: http://community.hortonworks.com/questions/801/oozie-hive-action-hive-sitexml-permission-denied.html Not received any response yet, but we can reach out to Engg team.
... View more
- « Previous
- Next »