About aervits

aervits · ‎06-24-2016

Yes you need to move to non-default database to avoid such issues. derby is not meant for concurrent access.

aervits · ‎06-23-2016

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.4.0/bk_installing_manually_book/content/download-companion-files.html please replace wget http://public-repo-1.hortonworks.com/HDP/tools/2.4.0.0/hdp_manual_install_rpm_helper_files-2.4.0.0.$BUILD.tar.gz tar zxvf hdp_manual_install_rpm_helper_files-2.4.0.0.169.tar.gz with wget http://public-repo-1.hortonworks.com/HDP/tools/2.4.0.0/hdp_manual_install_rpm_helper_files-2.4.0.0.169.tar.gz tar zxvf hdp_manual_install_rpm_helper_files-2.4.0.0.169.tar.gz

aervits · ‎06-23-2016

I believe there's a linking issue in documentation when you view page https://docs.hortonworks.com/HDPDocuments/Ambari-2.2.2.0/bk_ambari_reference_guide/content/ch_setting_up_an_internet_proxy_server_for_ambari.html then hit next page, it goes to chapter 10 now if you hit prev it will link not to the original link but to https://docs.hortonworks.com/HDPDocuments/Ambari-2.2.2.0/bk_ambari_reference_guide/content/_how_to_set_up_an_internet_proxy_server_for_ambari.html and if you hit prev again, only then do you return to the original page

aervits · ‎06-20-2016

If you have an immediate need for Spark 1.6.1, consider upgrading to HDP 2.4.2 otherwise stay on 2.3.4, there are no other changes between two releases.

aervits · ‎06-19-2016

a little update, function st_asgeojson only returns a JSON representation of geometry, to really make it useful, you still need to convert it to ST_Geometry type, with that object you can take full advantages of ESRI framework create temporary function st_geomfromgeojson as 'com.esri.hadoop.hive.ST_GeomFromGeoJson'; select st_geomfromgeojson(st_asgeojson(shape)) from table;

aervits · ‎06-18-2016

It is geometry in SQL Server and in Hive it is binary.

aervits · ‎06-18-2016

solved with add jar hdfs://namenode:8020/tmp/esri/esri-geometry-api.jar; add jar hdfs://namenode:8020/tmp/esri/spatial-sdk-hive-1.1.1-SNAPSHOT.jar; add jar hdfs://namenode:8020/tmp/esri/spatial-sdk-json-1.1.1-SNAPSHOT.jar; use default; create temporary function st_asgeojson as 'com.esri.hadoop.hive.ST_AsGeoJson'; select st_asgeojson(shape) from table;

aervits · ‎06-18-2016

@Predrag Minovic I had the same train of thought though unfortunately I was not able to treat it as well known binary. The only way I was able to process it so far was either by base64 encoding it or using the ESRI JSON serialization, at which point I was still stuck. I may have to ingest the column in different format perhaps.

aervits · ‎06-17-2016

I can't seem to find an applicable UDF to convert base64 string or binary type to an ESRI equivalent geometry type. Can someone recommend a solution? I'm aware of Brandon Wilson's awesome article on HCC.

aervits · ‎06-17-2016

Run MySQL install on that machine manually to resolve dependency issues, you have conflicts between MariaDB and MySQL

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

Member Since	‎10-01-2015 11:46 AM
Last Visited	‎08-15-2019 06:35 AM
Posts	3,933
Kudos received	1074

Cloudera Community

Re: Where can I get latest resource_management.c...

Re: How to Kerberize Flume?

Re: Load Hive Table form Pig Output File.

Re: HDP 2.6 Cluster Issues with Hive Metastore

Re: which HDP release will storm 1.1.0 be packaged...

Re: Concurrent access to the Sqoop metastore

$BUILD appears instead of HDP build number on down...

Ambari proxy documentation

Re: Is it recommended to use HDP 2.4 in production...

Re: I have a binary column in Hive, what is the eq...

Re: I have a binary column in Hive, what is the eq...

Re: I have a binary column in Hive, what is the eq...

Re: I have a binary column in Hive, what is the eq...

I have a binary column in Hive, what is the equiva...

Re: Hello, i am installing a singe node cluster, a...