Installed CPU UBUNTU version getting error in SELECT


#1

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?


#2

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


#3

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?


#4

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$