Stored procedures in Spark ?

05 May 2018 1 9K Report

I am migrating from PostgreSQL to Hive and I have a few stored procedures that used to be in postgres. I would like to know if it is possible to write stored procedure in spark, and if it is not possible what solution would be the best.

Thanks

Hossein Azgomi

Hi Chems

The Spark platform in the Design Pattern Framework 4.5 does support stored procedures. For more information see this:

http://www.dofactory.com/topic/1786/spark-and-stored-procedures.aspx

Badges
Science topic

More Chems Bezzaz's questions See All

Bytes data type in Hive ?

I have a column in table which values are like this : 0102000020E610000005000000FFFFFF, their data type is BYTE however Hive doesn't seem to support a BYTE type. What should I do ?

04 May 2018 2,271 3 View

How to write a spark function ?

I have a function written in SQL and I would like to write it in Spark how should I proceed. Thanks. The function is like this: CREATE OR REPLACE FUNCTION grid( widthx double precision,...

04 May 2018 4,698 3 View

Hive UDF Error ?

I have the function below which is supposed to calculate azimuth it has to do the same job as ST_Azimuth of PostGIS in Postgresql. (st_azimuth.png) When I execute the function in Java I get a...

04 May 2018 5,779 0 View

How to define big data ?

In the relational databases the data sets are always in a pristine condition, making data that way take a lot of time and effort which make the task of handling a big volume of data hard. As an...

03 April 2018 8,920 1 View

Can we talk about intensive computing when the size of the data is not huge ?

I would like to know if when talking about intensive computing it means that the data that we are working with is big ?

03 April 2018 1,919 3 View

How to resolve a computing intensive problem ?

In order to resolve a computing intensive problem I'm working with a lot of recursive function, whoever i don't get a good answer in a short amount of time and sometimes I do get stack overflowing...

03 April 2018 5,919 2 View

How to cast a problem to make it suitable for a distributed execution ?

I have an algorithm which is running in a sequential way however, I don't get the desired performance especially when it comes to execution time and i would like to remodel it to make it suitable...

03 April 2018 8,753 3 View

Intersection spatial big data ?

How to do intersection between a point (x, y) and a table containing polygons (cells) to match the points to the cells in the context of Spatial Big Data ?

01 February 2018 551 3 View

How to report results of Generalised Linear Mixed Models in a journal article?

Hi everyone, If you have written or come across any papers where Generalised Linear Mixed Models are used to examine intervention (e.g., in mental health) efficacy, could you please share the...

04 August 2024 4,130 4 View

The question is how to use Wavenet transform?

HOW CAN I WRITE A CODE TO USE THE WAVENET TRANSFORM AS A FEATURE EXTRACTION METHOD INSTEAD OF DWT IN MATLAB?

03 August 2024 7,829 0 View

PhD thesis topic?

I want to write a topic for my PhD thesis in hospitality (hotels), can u please suggest some variables

29 July 2024 9,058 3 View

What are the main types of errors and causes that English major college students commit in their English writing?

a 15-page paper

29 July 2024 1,956 5 View

I did hirshfeld surface analysis for molecule but did not find red spot and interaction surface in energy frame work, is it ok for research article ?

In hirshfeld surface calculation i did not find any red spot in hirshfeld surface, is it ok for research article to write?

28 July 2024 2,988 0 View

How can I find writers for drafting, submitting, and publishing papers?

Looking for paper collaboration writers： Collaboration Model 1: 1.1 Based on the chosen topic, complete the paper writing, select an SCI or SSCI Q1 journal, submit using my QRCID, and complete...

27 July 2024 8,965 1 View

Given currenct advances in the AI and Smart Computation, what are the prospects of having truly Humanoid Computing Devices in support of Education?

Today, many priorities for improvements to teaching and learning are unmet. Educators seek technology-enhanced approaches addressing these priorities that would be safe, effective, and scalable....

26 July 2024 8,544 4 View

What are cultural bereavement practices of Jamaica that do not conflict with the Christian faith?

I am writing my thesis on the enculturation of Jamaican grief and bereavement practices that enhances their Christian faith and not diminish it.

23 July 2024 3,837 0 View

What are the key risks associated with foodborne pathogens in imported leafy greens, the impact on public health and effect on regulatory framework?

I am currently writing a systematic review

15 July 2024 9,176 1 View

How to start writing an anti-virus software ?

I read several information security books. How do I start writing anti-virus softwares ？

13 July 2024 8,180 1 View