# 全流程试用

## 注册账号

请发送邮件到<yuping322@gmail.com>，申请试用

创建一个用户。并把用户加到default组织下

```bash
curl -X 'POST' \
  'http://roapi-cloud.com/api/default/users' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -d '{
  "email": "test@roapi-cloud.com",
  "first_name": "test",
  "last_name": "test",
  "password": "test123",
  "role" : "admin"
}'


```

创建一个组织test，并且该用户加到该组织下，角色为admin

```bash
curl -X 'POST' \
  'http://roapi-cloud.com/api/test/users/test%40roapi-cloud.com' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -d '{
  "role": "admin"
}'

```

## 下载测试数据

```bash
curl -L https://zinc-public-data.s3.us-west-2.amazonaws.com/zinc-enl/sample-k8s-logs/k8slog_json.json.zip -o k8slog_json.json.zip
unzip k8slog_json.json.zip
```

## 上传数据到云存储中

用以上创建的<test@roapi-cloud.com>和密码test123

```bash
curl http://roapi-cloud.com/api/default/default/_json -i -u "test@roapi-cloud.com:test123"  -d "@k8slog_json.json"
```

看到数据提交成功

```bash
{"code":200,"status":[{"name":"default","successful":3846,"failed":0}]}
```

## 云接口查询

```bash
curl -u "test@roapi-cloud.com:test123" -X 'POST' \
  'http://roapi-cloud.com/api/default/_search' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -d '{
  "aggs": {
    "histogram": "select histogram(_timestamp, '\''30 second'\'') AS zo_sql_key, count(*) AS zo_sql_num from query GROUP BY zo_sql_key ORDER BY zo_sql_key"
  },
  "query": {
    "end_time": 1675185660872049,
    "from": 0,
    "size": 10,
    "sql": "select * from k8s ",
    "start_time": 1675182660872049
  }
}'

```

## 下载云版本roapi

地址：<https://github.com/roapi-cloud/roapi-cloud/releases/>

```bash
wget https://github.com/roapi-cloud/roapi-cloud/releases/download/v0.01/roapi_linux_amd32.tar.gz
```

## 查询meta获取该组织下有权限的数据

```bash
curl -u "test@roapi-cloud.com:test123" -X 'GET' \
  'http://roapi-cloud.com/api/default/streams' \
  -H 'accept: application/json'
```

## 本地启动roapi程序

```bash
./roapi  --table "test=s3://testfegz/files/default/logs/default/,format=parquet"
```

## 查询本地数据

```bash
curl -X POST -d "SELECT count(*) FROM test " localhost:8080/api/sql

localhost:8080/api/tables/test?columns=kubernetes_container_name,kubernetes_labels_controller_revision_hash&limit=12
```

## 从云端定期更新meta，并注册本地表

```bash
curl -X POST http://localhost:8080/api/table \
   -H 'Content-Type: application/json' \
   -d '[
    {
        "tableName": "tt123",
        "uri": "s3://testfegz/files/default/logs/default/,format=parquet"
    }
]'
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://doc.roapi-cloud.com/docs/quickstart2.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.