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.

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

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

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

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.

Running a sample query

Go the SQL Worksheet and try out the following queries:

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 │
└───────┴──────────┘

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

Try out ByteHouse's in-built data visualisation
Click the data visualisation tab, choose Chart Type = Bar, X-Axis = mcc, and Y-Axis = count()

Connect to a BI-tool
Connect to Tableau. Select Longitude and Latitude as dimensions and Tableau will automatically convert it to a map graph