Exploratory
Search…
Exploratory
Introduction
Product Features
Data Import
File Data
Database Data
SQL Troubleshooting
Create Connection
Amazon Athena
Amazon Aurora
Amazon Redshift
Amazon Redshift (日本語)
Google BigQuery
HP Vertica
MariaDB / MySQL DB
MariaDB / MySQL DB (日本語)
Microsoft Access
MongoDB
ODBC
PostgreSQL
PostgreSQL (日本語)
Presto
Snowflake
SQLServer (DSN)
SQLServer
Teradata
Treasure Data
Cloud Apps Data
Write R Script as Data
Write R Script as Data (日本語)
Web Page Scraping
Free Input Text
Data Source Extension
Create Custom Data Source
Data Wrangling
Visualization
Analytics
Statistics
Machine Learning
Text Analysis
Extend with R
Setup
Diagnostics
Keyboard shortcuts
Powered By
GitBook
HP Vertica
You can quickly import data from your HP Vertica Database into Exploratory.
1. Create a Connection to use
Create a connection following
this instruction
.
2. Open HP Vertica Import dialog
Click '+' button next to 'Data Frames' and select 'Import Database Data'.
Click HP Vertica to select.
3. Import
1.
Put data frame name.
2.
Select connection from left dialog box.
3.
Write a query in the input field.
4.
Click "Preview" button. Then you will see the preview of the data.
5.
Click "Import" button.
If it looks ok, then you can click 'Import' to import the data into Exploratory.
4. Using Variables in SQL
First, create a custom R script.
Second, define a variable in the R script and save.
1
cutoff_date <- "\'2016-01-15\'"
Copied!
Note that the ‘\’ (backslash) symbols are used to escape the single quotes, which are required to be used for characters in SQL queries.
Finally, you can use @{} to surround a variable name inside the query like below.
1
select *
2
from airline_2016_01
3
where fl_date > @{cutoff_date}
Copied!
Here's a
blog post
for more detail.
Previous
Google BigQuery
Next
MariaDB / MySQL DB
Last modified
6mo ago
Copy link
Contents
1. Create a Connection to use
2. Open HP Vertica Import dialog
3. Import
4. Using Variables in SQL