so i followed step by step installation of CPU UBUNTU version.
i extracted sample dataset 2 i.e. flights_2008_10k
when i go to the folder i can see that file is there.
when i run the select program on the same location i get error as object flights_2008_10k not found.
can anyone help?
you have to launch insert_sample_data script that’s located on MAPD_HOME, select the dataset you are interested in and check that’s all is executed without errors.
the script would download the dataset, decompress it, create the table and insert the data
I did that …
i ran "sudo /opt/mapd/insert_sample_data "
which gave me an option to chhose a dataset and i chose 2 which is “flight_2008_10k”
then i open mapdql and run the select command
“SELECT origin_city AS “Origin”, dest_city AS “Destination”, AVG(airtime) AS “Average Airtime” FROM flights_2008_10k WHERE distance < 175 GROUP BY origin_city, dest_city;”
what am i missing?
When i tried the script in may/ June I don’t remember exactly, gunzip core dumped on ubunto so i hadn’t the table created nor data inserted; I have no idea what going on with your system.
At time I created the tables on my own and loaded my data.
Try to connect to mapd default database with mapdql command and create a sample table to check everything is working
here is the full output of insert_sample_data script on my system
mapd@zion-ubuntu:/opt/mapd/mapd-ce-3.3.0-20171026-ed76a7a-Linux-x86_64-render$ ./insert_sample_data
/opt/mapd/mapd-ce-3.3.0-20171026-ed76a7a-Linux-x86_64-render/sample_datasets /opt/mapd/mapd-ce-3.3.0-20171026-ed76a7a-Linux-x86_64-render
--2017-11-17 05:01:40-- https://data.mapd.com/manifest.tsv
Risoluzione di data.mapd.com (data.mapd.com)... 72.28.97.165
Connessione a data.mapd.com (data.mapd.com)|72.28.97.165|:443... connesso.
Richiesta HTTP inviata, in attesa di risposta... 200 OK
Lunghezza: 192 [application/octet-stream]
Salvataggio in: "manifest.tsv"
manifest.tsv 100%[===============================================================>] 192 --.-KB/s in 0s
2017-11-17 05:01:40 (74,5 MB/s) - "manifest.tsv" salvato [192/192]
/opt/mapd/mapd-ce-3.3.0-20171026-ed76a7a-Linux-x86_64-render
Enter dataset number to download, or 'q' to quit:
# Dataset Rows Table Name File Name
1) Flights (2008) 7M flights_2008_7M flights_2008_7M.tar.gz
2) Flights (2008) 10k flights_2008_10k flights_2008_10k.tar.gz
3) NYC Tree Census (2015) 683k nyc_trees_2015_683k nyc_trees_2015_683k.tar.gz
3
/opt/mapd/mapd-ce-3.3.0-20171026-ed76a7a-Linux-x86_64-render/sample_datasets /opt/mapd/mapd-ce-3.3.0-20171026-ed76a7a-Linux-x86_64-render
- downloading and extracting nyc_trees_2015_683k.tar.gz
--2017-11-17 05:02:00-- https://data.mapd.com/nyc_trees_2015_683k.tar.gz
Risoluzione di data.mapd.com (data.mapd.com)... 72.28.97.165
Connessione a data.mapd.com (data.mapd.com)|72.28.97.165|:443... connesso.
Richiesta HTTP inviata, in attesa di risposta... 200 OK
Lunghezza: 54572184 (52M) [application/octet-stream]
Salvataggio in: "nyc_trees_2015_683k.tar.gz"
nyc_trees_2015_683k.tar.gz 100%[===============================================================>] 52,04M 4,05MB/s in 15s
2017-11-17 05:02:16 (3,53 MB/s) - "nyc_trees_2015_683k.tar.gz" salvato [54572184/54572184]
nyc_trees_2015_683k/
nyc_trees_2015_683k/nyc_trees_2015_683k.csv
nyc_trees_2015_683k/nyc_trees_2015_683k.sql
/opt/mapd/mapd-ce-3.3.0-20171026-ed76a7a-Linux-x86_64-render
- adding schema
User mapd connected to database mapd
User mapd disconnected from database mapd
- inserting file: /opt/mapd/mapd-ce-3.3.0-20171026-ed76a7a-Linux-x86_64-render/sample_datasets/nyc_trees_2015_683k/nyc_trees_2015_683k.csv
User mapd connected to database mapd
Result
Loaded: 683788 recs, Rejected: 0 recs in 4.616000 secs
User mapd disconnected from database mapd
mapd@zion-ubuntu:/opt/mapd/mapd-ce-3.3.0-20171026-ed76a7a-Linux-x86_64-render$