# BigTableViewer

**Repository Path**: liuyouzhang/BigTableViewer

## Basic Information

- **Project Name**: BigTableViewer
- **Description**: No description available
- **Primary Language**: Java
- **License**: MIT
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-06-10
- **Last Updated**: 2024-06-10

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Big Table Viewer

[![Build Actions Status](https://github.com/erikmafo/BigTableViewer/workflows/Build/badge.svg)](https://github.com/erikmafo/BigTableViewer/actions)
[![Codacy Badge](https://app.codacy.com/project/badge/Coverage/9364e25dcac647f2b0019e61235a5f00)](https://www.codacy.com/gh/erikmafo/BigTableViewer/dashboard?utm_source=github.com&utm_medium=referral&utm_content=erikmafo/BigTableiewer&utm_campaign=Badge_Coverage)
[![Codacy Badge](https://api.codacy.com/project/badge/Grade/6e70e5faa1bc418093f4454f945336ed)](https://app.codacy.com/gh/erikmafo/BigTableViewer?utm_source=github.com&utm_medium=referral&utm_content=erikmafo/BigTableViewer&utm_campaign=Badge_Grade_Settings)
[![CodeQL Analysis Actions Status](https://github.com/erikmafo/BigTableViewer/workflows/CodeQL/badge.svg)](https://github.com/erikmafo/BigTableViewer/actions)

Big Table Viewer is an application that lets you query the contents of Google Bigtable tables with SQL. 

## Installation

Download and run the [installer](https://github.com/erikmafo/BigTableViewer/releases/latest) 
for your operating system.

## Basic Usage

To use different credentials than GOOGLE_APPLICATION_CREDENTIALS, click on 'File'->'Set credentials'.

To add a Bigtable instance click on 'Add instance', enter the project and instance id and click 'Ok'. 
The application should display all the tables of the instance.

Click on the table that you would like to query. A default query, selecting the first 1000 rows of the selected table, 
should appear in the query box. Click 'Execute' to execute the query.

## Table schema

Big table viewer works best with tables where the data in each column corresponds to a standard data type. By clicking 
on 'Table settings' you can configure how the application should interpret the columns in your table.

## Query examples

Use 'KEY' to reference the row key:
```sql
SELECT * FROM 'table-0' WHERE KEY LIKE 'row-.*' LIMIT 1000
```
Use . to reference a column in a column family:
```sql
SELECT * FROM 'table-0' WHERE myFamily.myIntColumn > 0 LIMIT 1000
```
Filter rows based on the value of a column or row key by using standard operators '>', '<', '>=', '<=', '=', '!=', e.g.
```sql
SELECT * FROM 'table-0' WHERE myFamily.myStringColumn = 'foo' LIMIT 1000
```
Use 'AND' to combine filters:
```sql
SELECT * FROM 'table-0' WHERE KEY LIKE 'rowkey.*' AND myFamily.myStringColumn = 'foo' LIMIT 1000
```
Only select data from a specific column family:
```sql
SELECT myFamily FROM 'table-0' LIMIT 1000
```
or a list of columns:
```sql
SELECT myFamily.column1, myFamily.column2  FROM 'table-0' LIMIT 1000
```
Filter data based on the cell timestamp:
```sql
SELECT * FROM 'table-0' WHERE TIMESTAMP < '2020-12-13 12:54' LIMIT 1000
```
Count the number of rows satisfying a condition:
```sql
SELECT COUNT(*) FROM 'table-0' WHERE TIMESTAMP < '2020-12-13 12:54'
```
Count the number of rows within a column family satisfying a condition:
```sql
SELECT COUNT(myFamily) FROM 'table-0' WHERE TIMESTAMP < '2020-12-13 12:54'
```
To work with reverse row keys, use the built-in REVERSE function:
```sql
SELECT * FROM 'table-0' WHERE KEY LIKE REVERSE('yekwor') LIMIT 1000
```
in combination with CONCAT:
```sql
SELECT * FROM 'table-0' WHERE KEY LIKE CONCAT(REVERSE('yekwor'), '#', '2020-12.*') LIMIT 1000
```
## Licence

See [licence file](LICENSE).