# go-log

**Repository Path**: fun-study/go-log

## Basic Information

- **Project Name**: go-log
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-11-22
- **Last Updated**: 2025-05-26

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 设置代理

```shell
# 设置代理地址
go env -w GOPROXY=https://goproxy.cn
# 设置完后 重新执行即可go get

# add missing and remove unused modules
go mod tidy
#  add dependencies to current module and install them
go get xxxxx
```

# 编译

```shell
# 构建 Linux 版本
GOOS=linux GOARCH=amd64 go build
# 构建 ARM 版本
GOOS=linux GOARCH=arm GOARM=7 go build
```

# 日志格式

```shell
%d{yyyy-MM-dd HH:mm:ss.SSS}|%-5p|%tid|%t|%c:%L|%m%n
```

# doris数据库
```sql
-- 删除表
DROP TABLE logs;

-- 查看建表语句
SHOW CREATE TABLE  logs;

-- 查看分区信息
SHOW PARTITIONS FROM logs;

-- 建表语句
CREATE TABLE IF NOT EXISTS logs
(
    -- KEY列
    `ts` DATETIME(3) NOT NULL COMMENT "日志时间",
    `app_name` VARCHAR(30) NOT NULL COMMENT "应用名称",
    `node_id` VARCHAR(10) NOT NULL COMMENT "节点名称",
    -- VALUE列
    `level` VARCHAR(10) NOT NULL COMMENT "日志级别",
    `trace_id` VARCHAR(100) NOT NULL COMMENT "traceId",
    `thread_name` VARCHAR(200) NOT NULL COMMENT "线程名称",
    `class_name` VARCHAR(200) NOT NULL COMMENT "类名",
    `line_number` int NOT NULL COMMENT "行号",
    `context` STRING COMMENT "日志内容",
    INDEX idx_context(context) USING INVERTED PROPERTIES("parser" = "unicode", "support_phrase" = "true")
)
-- 数据表模型 DUPLICATE模型
DUPLICATE KEY(`ts`, `app_name`, `node_id`)
PARTITION BY RANGE (ts) ()
DISTRIBUTED BY HASH(`app_name`) BUCKETS 32
PROPERTIES
(
    "replication_num" = "1",
    "dynamic_partition.time_unit" = "DAY",
    "dynamic_partition.start" = "-30",
    "dynamic_partition.end" = "1",
    "dynamic_partition.prefix" = "p",
    "dynamic_partition.buckets" = "32",
    "dynamic_partition.replication_num" = "1"
);
```

## 倒排查询
https://doris.apache.org/zh-CN/docs/table-design/index/inverted-index