Spark SQL magic command for Jupyter notebooks
Project description
sparksql-magic
Spark SQL magic command for Jupyter notebooks.
Prerequisites
- Python >= 3.6
- PySpark >= 2.3.0
- IPython >= 7.4.0
Install
pip install sparksql-magic
Usage
Load
%load_ext sparksql_magic
Config
%config SparkSql.max_num_rows=<INT>
Option | Default | Description |
---|---|---|
SparkSql.max_num_rows |
20 | The maximum number of rows to display |
Parameter
%%sparksql [-c] [-v VIEW] [variable]
<QUERY>
Parameter | Description |
---|---|
-c --cache |
Cache dataframe |
-e --eager |
Cache dataframe with eager load |
-v VIEW --view VIEW |
Create or replace temporary view |
variable |
Capture dataframe in a local variable |
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
sparksql-magic-0.0.2.tar.gz
(3.0 kB
view hashes)
Built Distribution
Close
Hashes for sparksql_magic-0.0.2-py36-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d7e3f959a12cc2fe3adc7a8dcdec50380b3b90967842e386b41beba323398f49 |
|
MD5 | f1dc031e355737c7d1a2ddbf648e491e |
|
BLAKE2b-256 | c820476cc23398970731b6fd4ebe1921d56dec9580dd407025da391645310c98 |