tencent cloud

TCHouse-P
Download PDF
Last updated: 2024-11-01 16:26:14
TCHouse-P
Last updated: 2024-11-01 16:26:14
Download PDF
Note:
You need to bind TCHouse-P engine.
Permissions for the corresponding TCHouse-P databases and tables need to be set in TCHouse-P.

Feature Overview

Submit a TCHouse-P task execution to the WeData workflow scheduling platform.

Sample code:

-- Create a database
CREATE DATABASE wedata_demo_db;
Switch the database to the corresponding one in the TCHouse-P task.



Execute SQL on the task page:
-- Create schema
CREATE SCHEMA demo;

-- Create a table
CREATE TABLE demo.user_info (
  id SERIAL PRIMARY KEY,
  name VARCHAR(255) NOT NULL
);

-- Insert data
INSERT INTO demo.user_info (name) VALUES ('Alice'), ('Bob');


-- View data
select * from  demo.user_info;

-- View the schema of the corresponding database 
SELECT schema_name 
FROM information_schema.schemata 
WHERE catalog_name = 'wedata_demo_db';

-- View tables in the corresponding schema
SELECT table_name 
FROM information_schema.tables 
WHERE table_schema = 'demo';

Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback