Comments (2)
Thanks for opening this issue! Based on our automated check, it seems that your post contains some code but it does not use code blocks to format it.
Please double-check your post and revise it if necessary. To employ syntax highlighting, it's recommended to use code blocks with triple backticks, e.g.:
```sql
SELECT ...
```
If this is a false positive, feel free to disregard this comment.
from duckdb.
Thanks for the report! I've pushed a fix in #11825.
Using string literals as input to columns
would also resolve this issue, e.g.:
CREATE OR REPLACE VIEW actions AS
SELECT *
FROM read_csv('nasdaq-data-link/SHARADAR/ACTIONS-2024-04-23.csv.zst', columns={'date': 'date', 'action': 'varchar', 'ticker': 'varchar', 'name': 'varchar', 'value': 'varchar', 'contraticker': 'varchar', 'contraname': 'varchar'}, header=true, dateformat='%Y-%m-%d')
from duckdb.
Related Issues (20)
- python read_csv prepared statement requires numpy, non-prepared statement doesn't.
- Clearing fsspec filesystem caches segfaults Python runtime HOT 1
- Default quote char must be "
- Container Overflow when calling DuckDB constructor HOT 4
- JSON_GROUP_STRUCTURE is now (incorrectly?) case sensitive HOT 4
- Partitioned CSV writes with gzip do not add `.csv.gz` extension and fail to read back in with `read_csv_auto` HOT 4
- Quarter doesn't work as interval in window functions HOT 2
- `MAX_BY` and `MIN_BY` return wrong results when using old_implicit_casting HOT 20
- ifnull returns an error when chained (nullif works) HOT 4
- Upsert complains about lack of constrains despite the fact they are present HOT 4
- 'Duplicate key' error when update column with list data type and table has a primary key HOT 3
- Compilation warnings in re2 with `-Wpedantic` HOT 10
- Running simple `SELECT` over S3 attached DuckDB db segfaults HOT 4
- Wrong comparison for timestamp depending on if it's in a subquery or not HOT 2
- PIVOT does not support geomean as aggregation function HOT 2
- error when inserting duped values into primary column with many values HOT 1
- `CAST( 'yes' AS BOOLEAN)` fails HOT 3
- No facility to parse formatted Number Strings to Numeric/Double/Decimal HOT 2
- MemoryError: std::bad_alloc HOT 7
- `Round()` and `Round_Even()` return different type HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from duckdb.