About grajagopal

grajagopal · ‎05-06-2016

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.

grajagopal · ‎04-07-2016

Thanks @Kuldeep Kulkarni

grajagopal · ‎04-07-2016

Does hiveserver2 JDBC calls support TLSv1.2 ? We are having external applications configured to use TLS1.2 for stronger security.

grajagopal · ‎02-15-2016

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 !

grajagopal · ‎02-15-2016

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!

grajagopal · ‎01-07-2016

Thank you very much @zblanco. It worked perfectly fine. Also thank you very much for the reference API.

grajagopal · ‎01-07-2016

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

grajagopal · ‎11-03-2015

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!

grajagopal · ‎11-02-2015

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!

grajagopal · ‎10-06-2015

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.

Online	Offline
Last Visited	‎08-15-2019 06:35 AM

Member Since	‎09-10-2015 05:52 PM
Last Visited	‎08-15-2019 06:35 AM
Posts	54
Kudos received	24

Cloudera Community

Re: Apache Sqoop : How Sqoop can be used with Java...

Re: How to remove header and footer from a CSV fil...

Re: Converting Lab3 PIG script to HIVE

Re: Falcon Passing parameters to existing Oozie Wo...

Re: Hi, Is there a way to load xlsx file into hive...

Re: Do Hiveserver2 direct JDBC Calls Support TLS1....

Do Hiveserver2 direct JDBC Calls Support TLS1.2 ?

Re: pig script status running but always remain at...

Re: pig and hive store

Re: Ambari Alert REST API to filter out services o...

Ambari Alert REST API to filter out services on ma...

Re: TRIM on Hive Decimal Datatype

TRIM on Hive Decimal Datatype

Re: Failing Oozie Launcher threw exception, hive-s...