1,953 questions
-1
votes
1
answer
114
views
Why must key columns of a Doris table be placed before other columns?
The create table statement in Apache Doris is confusing to me. I want to create a table, but I must put the key columns before other columns, otherwise I will get an error.
I will follow this rule, ...
- 78
0
votes
1
answer
42
views
Error "[E-238] Too many segments in rowset" in Apache Doris
When I execute 'ctas' statement in Apache Doris, I get the error below:
[E-238] Too many segments in rowset
the detail SQL is:
CREATE TABLE MY_DB_NAME.MY_TABLE_NAME AS
SELECT T1.DATA_DATE AS SDATE, ...
- 78
0
votes
2
answers
119
views
What does the "KEY" keyword used by itself do?
I'm using SQLite 3.40.1. The documentation does not mention the KEY keyword used without PRIMARY, but I am able to create tables with a column of attribute KEY:
CREATE TABLE junk(a INTEGER PRIMARY KEY ...
0
votes
1
answer
32
views
Django - ValueError at /selected-events/ Cannot assign ... must be a "Profile" instance
I have a Django project that consists of, essentially, 3 datasets: auth User (plus a Profile dataset), mem_ev and Events such that User --< mem_ev >-- Event, ie a classic many to many ...
- 529
1
vote
1
answer
71
views
Can I use a sequence in a create-table definition in PostgreSQL? [closed]
I am trying to write a PostgreSQL script that meets the following requirements:
Create a table with two columns, Id and Id2, which must always have identical values when a record is added to the ...
0
votes
1
answer
36
views
R DBI dbSendStatement not working for CREATE TABLE
Reading through the reference material-
https://dbi.r-dbi.org/reference/dbSendStatement.html
Is there are reason the below code doesn't create the temp table?:
if (!require("pacman")
) ...
- 329
-1
votes
1
answer
76
views
How to make a column in a table with a float value in SQLite?
I'm making a table in a database, and one of the columns needs to store a float number. However, I keep getting an error under the name of the float value when I ask my SQLiteDatabase to create the ...
0
votes
0
answers
124
views
ssms 20.1 tasks/generate scripts fails
running ssms 20.2, selecting database, right-click, choosing tasks then generate scripts. I select tables I want scripted and get a message that script generation failed and I am instructed to click ...
2
votes
1
answer
2k
views
How to create a PARTITIONED table in Python using PyIceberg with pyarrow
business_time
value
2024-06-29 05:00:03.287073252+00:00
1.3
2024-06-29 11:00:03.504073740+00:00
1.4
I am trying to create a partitioned table using the python code from the given DataFrame (see above)....
- 51
-1
votes
1
answer
52
views
Error while creating a table joining two tables in pgadmin
I have two tables one is customer data, and the other is geography data which has a common field geography key. I joined the two tables using the following query:
SELECT c.*, g.*
FROM customer AS c
...
0
votes
1
answer
32
views
Converting DDL MasterFile table to SQL Server table, How do I write in missing data?
I am working on converting DDL master files to SQL Server tables, and every one of them have MISSING=ON in the file, which I am interpreting as "if missing then make aware" sort of thing. ...
0
votes
1
answer
66
views
Oracle DB - Create Table As - causes "ORA-01489: result of string concatenation is too long"
I found a weird behavior in a stored procedure that works 99% of the time fine for historizing a standardized report into our Oracle Database.
For some reports I get the error ORA-01489: result of ...
- 755
0
votes
1
answer
86
views
What is the correct syntax for creating a table name as variable?
The user can generate a table to rank songs. It checks if there is a ranking system for the user already, if not it creates a new table. I want the name of the system to correlate with the user id.
@...
-1
votes
1
answer
248
views
Why does my CREATE TABLE statement return an "incomplete input" error?
The cursor returns an error.
main.py:
def initialize_database():
conn = sqlite3.connect('PostsData.db')
cursor = conn.cursor()
cursor.execute('''
CREATE TABLE IF NOT EXISTS posts (
...
- 1
3
votes
1
answer
175
views
Using CREATE TEMPORARY TABLE with pandas
I am trying to create a temporary table or drop a table in MySQL using SQLAlchemy in Jupyter notebook. The SQL function does create table or drops the table but it results in an error
...
