``` CREATE TABLE IF NOT EXISTS `tracing normal` `serviceName Greptime #general

``` CREATE TABLE IF NOT EXISTS `tracing_normal` ( ...

zhiqiang666 deng

08/29/2025, 3:26 AM

Copy code

CREATE TABLE IF NOT EXISTS `tracing_normal` (
  `serviceName` STRING NULL SKIPPING INDEX WITH(false_positive_rate = '0.01', granularity = '10240', type = 'BLOOM'),
  `agentIp` STRING NULL,
  `api` STRING NULL INVERTED INDEX,
  `bussId` STRING NULL,
  `componentId` STRING NULL,
  `deployType` STRING NULL,
  `error` STRING NULL,
  `idcId` STRING NULL,
  `ip` STRING NULL INVERTED INDEX,
  `parentSpanId` STRING NULL,
  `parentTraceSegmentId` STRING NULL,
  `parentService` STRING NULL,
  `parentServiceInstance` STRING NULL,
  `networkAddressUsedAtPeer` STRING NULL,
  `parentEndpoint` STRING NULL,
  `peer` STRING NULL,
  `refType` STRING NULL,
  `sdkType` STRING NULL INVERTED INDEX,
  `serviceInstance` STRING NULL,
  `spanId` STRING NULL,
  `spanKind` STRING NULL,
  `spanLayer` STRING NULL,
  `spanType` STRING NULL,
  `topic` STRING NULL,
  `traceId` STRING NULL SKIPPING INDEX WITH(false_positive_rate = '0.01', granularity = '10240', type = 'BLOOM'),
  `traceSegmentId` STRING NULL,
  `statusCode` STRING NULL INVERTED INDEX,
  `originServiceName` STRING NULL INVERTED INDEX,
  `env` STRING NULL INVERTED INDEX,
  `projectEnv` STRING NULL INVERTED INDEX,
  `p` SMALLINT NULL,
  `tags` JSON NULL,
  `logs` JSON NULL,
  `duration` BIGINT UNSIGNED NULL,
  `slowRequest` BIGINT UNSIGNED NULL,
  `ts` TIMESTAMP(3) NOT NULL,
  `endTime` BIGINT UNSIGNED NULL,
  `startTimeUs` BIGINT UNSIGNED NULL,
  TIME INDEX (`ts`),
  PRIMARY KEY (`serviceName`)
)
PARTITION ON COLUMNS (`p`) (
  p < 1,
  p >= 1 AND p < 2,
  p >= 2 AND p < 3,
  p >= 3 AND p < 4,
  p >= 4 AND p < 5,
  p >= 5 AND p < 6,
  p >= 6 AND p < 7,
  p >= 7 AND p < 8,
  p >= 8 AND p < 9,
  p >= 9 AND p < 10,
  p >= 10 AND p < 11,
  p >= 11 AND p < 12,
  p >= 12 AND p < 13,
  p >= 13 AND p < 14,
  p >= 14 AND p < 15,
  p >= 15 AND p < 16,
  p >= 16 AND p < 17,
  p >= 17 AND p < 18,
  p >= 18 AND p < 19,
  p >= 19 AND p < 20,
  p >= 20 AND p < 21,
  p >= 21 AND p < 22,
  p >= 22 AND p < 23,
  p >= 23 AND p < 24,
  p >= 24 AND p < 25,
  p >= 25 AND p < 26,
  p >= 26 AND p < 27,
  p >= 27 AND p < 28,
  p >= 28 AND p < 29,
  p >= 29 AND p < 30,
  p >= 30 AND p < 31,
  p >= 31 AND p < 32,
  p >= 32 AND p < 33,
  p >= 33 AND p < 34,
  p >= 34 AND p < 35,
  p >= 35 AND p < 36,
  p >= 36 AND p < 37,
  p >= 37 AND p < 38,
  p >= 38 AND p < 39,
  p >= 39 AND p < 40,
  p >= 40 AND p < 41,
  p >= 41 AND p < 42,
  p >= 42 AND p < 43,
  p >= 43 AND p < 44,
  p >= 44 AND p < 45,
  p >= 45 AND p < 46,
  p >= 46 AND p < 47,
  p >= 47 AND p < 48,
  p >= 48 AND p < 49,
  p >= 49 AND p < 50,
  p >= 50 AND p < 51,
  p >= 51 AND p < 52,
  p >= 52 AND p < 53,
  p >= 53 AND p < 54,
  p >= 54 AND p < 55,
  p >= 55 AND p < 56,
  p >= 56 AND p < 57,
  p >= 57 AND p < 58,
  p >= 58 AND p < 59,
  p >= 59 AND p < 60,
  p >= 60 AND p < 61,
  p >= 61 AND p < 62,
  p >= 62 AND p < 63,
  p >= 63 AND p < 64,
  p >= 64 AND p < 65,
  p >= 65 AND p < 66,
  p >= 66 AND p < 67,
  p >= 67 AND p < 68,
  p >= 68 AND p < 69,
  p >= 69 AND p < 70,
  p >= 70 AND p < 71,
  p >= 71 AND p < 72,
  p >= 72 AND p < 73,
  p >= 73 AND p < 74,
  p >= 74 AND p < 75,
  p >= 75 AND p < 76,
  p >= 76 AND p < 77,
  p >= 77 AND p < 78,
  p >= 78 AND p < 79,
  p >= 79 AND p < 80,
  p >= 80 AND p < 81,
  p >= 81 AND p < 82,
  p >= 82 AND p < 83,
  p >= 83 AND p < 84,
  p >= 84 AND p < 85,
  p >= 85 AND p < 86,
  p >= 86 AND p < 87,
  p >= 87 AND p < 88,
  p >= 88 AND p < 89,
  p >= 89 AND p < 90,
  p >= 90 AND p < 91,
  p >= 91 AND p < 92,
  p >= 92 AND p < 93,
  p >= 93 AND p < 94,
  p >= 94 AND p < 95,
  p >= 95 AND p < 96,
  p >= 96 AND p < 97,
  p >= 97 AND p < 98,
  p >= 98 AND p < 99,
  p >= 99 AND p < 100,
  p >= 100 AND p < 101,
  p >= 101 AND p < 102,
  p >= 102 AND p < 103,
  p >= 103 AND p < 104,
  p >= 104 AND p < 105,
  p >= 105 AND p < 106,
  p >= 106 AND p < 107,
  p >= 107 AND p < 108,
  p >= 108 AND p < 109,
  p >= 109 AND p < 110,
  p >= 110 AND p < 111,
  p >= 111 AND p < 112,
  p >= 112 AND p < 113,
  p >= 113 AND p < 114,
  p >= 114 AND p < 115,
  p >= 115 AND p < 116,
  p >= 116 AND p < 117,
  p >= 117 AND p < 118,
  p >= 118 AND p < 119,
  p >= 119 AND p < 120,
  p >= 120 AND p < 121,
  p >= 121 AND p < 122,
  p >= 122 AND p < 123,
  p >= 123 AND p < 124,
  p >= 124 AND p < 125,
  p >= 125 AND p < 126,
  p >= 126 AND p < 127,
  p >= 127
)
ENGINE=mito
WITH(
  skip_wal = 'true',
  ttl = '1h'
)

evenyag

08/29/2025, 8:20 AM

Looks like you didn’t use an append-only table? You may create an append-only table for this case. Otherwise, you may not be able to get the expected query result. You can read these documents for details: https://docs.greptime.com/user-guide/deployments-administration/performance-tuning/design-table/#deduplication https://docs.greptime.com/reference/sql/create/#create-an-append-only-table By default, tables in ClickHouse and druid are similar to the append-only table in GreptimeDB.

zhiqiang666 deng

08/29/2025, 8:24 AM

Thanks, I'll try it

2 Views

Open in Slack

Previous Next