Sample query

Loading sample data

You can learn how to load a small sample dataset (Cell Towers by OpenCellid) from our onboarding tour when you first visit our website. To repeat the tour, click on the (?) icon on the top right hand corner of the page after you have logged in to your account.

728 528

Alternatively, you can access the sample data from the button below on the Data Loading page.

2870

The fields are automatically populated. All you have to do is to choose [Create] to create a data loading job.

2870

After that, ByteHouse will prompt you to click [OK] to start the data loading job.

2036

Congratulations, you have completed the tour!

Please wait a while for the data loading job to be successful. It usually takes between 20-40s to initiate the resources and load the 100K rows of data.

2652

Running a sample query

Go the SQL Worksheet and try out the following queries:

  1. Select the number of cell towers by type.
SELECT radio, count() AS c
FROM sample_data.sample_data_cell_tower
GROUP BY radio ORDER BY c DESC

┌─radio─┬────────c─┐
│ UMTS  │ 20686487 │
│ LTE   │ 12101148 │
│ GSM   │  9931312 │
│ CDMA  │   556344 │
│ NR    │      867 │
└───────┴──────────┘
  1. Select cell towers by mobile country code (MCC).
SELECT mcc, count() 
FROM sample_data.sample_data_cell_tower
GROUP BY mcc ORDER BY count() DESC LIMIT 10

┌─mcc─┬─count()─┐
│ 310 │ 5024650 │
│ 262 │ 2622423 │
│ 250 │ 1953176 │
│ 208 │ 1891187 │
│ 724 │ 1836150 │
│ 404 │ 1729151 │
│ 234 │ 1618924 │
│ 510 │ 1353998 │
│ 440 │ 1343355 │
│ 311 │ 1332798 │
└─────┴─────────┘

Visualise the data

  1. Try out ByteHouse's in-built data visualisation
    Click the data visualisation tab, choose Chart Type = Bar, X-Axis = mcc, and Y-Axis = count()
978
  1. Connect to a BI-tool
    Connect to Tableau. Select Longitude and Latitude as dimensions and Tableau will automatically convert it to a map graph
3428