rtyler
/
dlsh
1
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
2 Commits
1 Branch
0 Tags
41 KiB
 
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'main'
${ noResults }
Go to file
R Tyler Croy 062452f094
Add an example 		2 years ago
src Initial commit with some simple support for querying 2 years ago
.gitignore Initial commit with some simple support for querying 2 years ago
Cargo.toml Initial commit with some simple support for querying 2 years ago
LICENSE.txt Initial commit with some simple support for querying 2 years ago
README.adoc Add an example 2 years ago

README.adoc

<html lang="en"> <head> </head>

Delta Lake Shell

dlsh is a shell for simple querying of Delta Lake tables.

dlsh> load ./data/COVID-19_NYT as covid
dlsh> select * from covid where county = 'Sonoma' order by date desc limit 5
+------------+--------+------------+------+-------+--------+
| date       | county | state      | fips | cases | deaths |
+------------+--------+------------+------+-------+--------+
| 2021-03-11 | Sonoma | California | 6097 | 28638 | 306    |
| 2021-03-10 | Sonoma | California | 6097 | 28601 | 306    |
| 2021-03-09 | Sonoma | California | 6097 | 28571 | 306    |
| 2021-03-08 | Sonoma | California | 6097 | 28533 | 303    |
| 2021-03-07 | Sonoma | California | 6097 | 28484 | 303    |
+------------+--------+------------+------+-------+--------+
dlsh> load ./data/simple_table as simple
dlsh> select * from covid where county = 'Sonoma' order by date desc limit 5
+------------+--------+------------+------+-------+--------+
| date       | county | state      | fips | cases | deaths |
+------------+--------+------------+------+-------+--------+
| 2021-03-11 | Sonoma | California | 6097 | 28638 | 306    |
| 2021-03-10 | Sonoma | California | 6097 | 28601 | 306    |
| 2021-03-09 | Sonoma | California | 6097 | 28571 | 306    |
| 2021-03-08 | Sonoma | California | 6097 | 28533 | 303    |
| 2021-03-07 | Sonoma | California | 6097 | 28484 | 303    |
+------------+--------+------------+------+-------+--------+
dlsh> select * from simple
+----+
| id |
+----+
| 5  |
| 7  |
| 9  |
+----+
dlsh>
Last updated 2023-03-31 16:20:40 -0700
</html>