SQL & PL/SQL
Submitted by jp_vijaykumar on Tue, 2022-03-08 10:50
##############################################
#cd /c/temp/;spark-submit.cmd pysparknaivebayes.py
"""
NAIVE BAYES ALGORITHM IN SQL. PL/SQL, SPARK SQL
Written: JP Vijaykumar
Date: Mar 8th 2022
********************************************************************************
This script is provided for educational purpose ONLY.
Submitted by jp_vijaykumar on Tue, 2021-09-14 11:43
"""
Apriori Algorithm in sql,pl/sql and spark sql
Written JP Vijaykumar
Date Sep 14 2021
********************************************************************************
This script is provided for educational purpose only.
The sql scripts were tested in 11g & 19c databases.
While testing the sql scripts, pls test it in a dev/test db only and exercise precaution.
Submitted by jp_vijaykumar on Mon, 2021-03-08 15:10
"""
Time Series Analysis in Spark SQL
Written JP Vijaykumar
Date Mar 8 2021
This script is provided for educational purpose only.
Pls modify/change the script as may be required to suit your environment.
I presented a script to process data using Time Series Analysis algorithm in sql and pl/sql earlier.
In this article, I am using the same code(90%) from my previous article and 10% pyspark code.
If you know sql, coding in pyspark is not that difficult.
Submitted by ashishkj on Tue, 2020-12-29 04:46
I want SQL queries for these two scenarios
Q. 1) Anagrams of a string i.e. let a name is RAMESH. So all combinations of letters of word RAMESH.
Probably a procedure needs to be written for this eg RAMESH, RHSEMA. There will be 6*5*4*3*2*1 combinations
Q.2 ) There is one table PERSON as follows:
Submitted by jp_vijaykumar on Mon, 2020-09-14 08:21
"""
Decision Tree Algorithm in Spark SQL
Written JP Vijaykumar
Date Sep 14 2020
This script is provided for educational purpose only.
Pls modify/change the script as may be required to suit your environment.
I presented a script to process decision tree algorithm using pl/sql earlier.
I like spark sql for the following reasons:
01) It is open source.
02) It combines the rich functionality of python and sql
03) It has the datamining libraries.
04) can be installed on my desktop and play around.
Submitted by John Watson on Tue, 2020-06-02 07:28
Recently I've been working on tuning some distributed queries. This is not always straightforward.
Submitted by jp_vijaykumar on Sun, 2020-03-08 11:02
TIME SERIES ANALYSIS IN SQL AND PL/SQL
Written JP Vijaykumar
Date Mar 8th 2020
Submitted by MIKEISMAD on Wed, 2019-12-04 15:14
From the below table example, I'm trying to identify only the records where VAL_IN changed. So I need to see only 4 records in the below example.
I've been reading about LEAD / LAG and think this is probably the function I need to use, but have not had luck with returning results. Can someone please help push me in the right direction.
Submitted by cristine_katia on Wed, 2019-11-13 15:21
Good afternoon people!
I have a procedure in Oracle with various functions of calculations, type simulator. So, I want to assemble a type with output parameters reading this data and bring the results of these functions in real time, because I want to display them as output lines on a front (web screen). I already created the types objects and table. However, I am having difficulty assembling, because I do not know well Type. Can someone help me? Thanks
Submitted by jp_vijaykumar on Sun, 2019-09-22 16:16
Decision Tree Algorithm in pl/sql
Author JP Vijaykumar
Date Sept 14th 2019
Pages
|
