Data & Schemas Knowledgebase
A solid data foundation leads to analytics. Build that foundation here.
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

How Joins Work in Incorta

Introduction Incorta supports the following types of joins: One-to-one (1:1) Many-to-one (M:1) Many-to-many (M:M) joins using Materialized Views Example: Simple Many-to-one (M:1) Join Tables: Sales table Customer table The Sales table has mult...

KailaT by Community Manager
  • 130 Views
  • 0 comments
  • 0 kudos

Getting Started with R in Incorta Notebook

Overview R is a popular language in Data Science.  Incorta supports creating materialized views (MV) with R. Your first Spark Program The minimum requirement for creating an MV includes the following: # Read data from Incorta into Spark df <- read(...

SparkR.png

Use SparkSQL with SparkR

Overview In this recipe, you’ll learn how to run SQL queries from SparkR. After using the read() Incorta Notebook extension function to load data in Incorta Notebook, the data is in a SparkR DataFrame. You can use sql() to write SQL queries after cr...

Screen Shot 2022-04-05 at 4.00.41 PM.png
suxinji by Employee
  • 107 Views
  • 0 comments
  • 0 kudos

ML with IRIS data set using Incorta

This article shows how to use a classification Machine Learning (ML) algorithm on the Iris Flower data set. It first creates a model based on a training data set and then scores the the test data set and gives the prediction of the flower based on th...

amit_kothari_0-1648226442596.png
Best Practices Index
Best Practices

Just here to browse knowledge? This might help!