Type casting in preview table in DataSpell when SQL query is output
I can't understand why Dataspell converts a text column to the integer type. I looked at the ddl table schema and there is a varchar type. But for some reason the integer type is displayed in the preview and statistics are provided for it. How can I explicitly prohibit this from happening in the settings?
SELECT DISTINCT CAST(year_ AS VARCHAR(4)), fid_hash
FROM mat_view.fns_2022_ind_metrics_by_fid_for_power_bi
LIMIT 100I tried to find settings to prevent this from happening, but I couldn't.
请先登录再写评论。
Please try upgrading IDE to the latest version, disabling all non-bundled plugins (**Settings | Plugins**, click the cog icon -> Disable All Downloaded Plugins) and check if the problem persists.
If the problem remains unresolved, we would like to investigate it properly. Please create an issue on YouTrack (https://youtrack.jetbrains.com/newIssue) regarding this problem. Attach relevant logs (Help | Collect Logs and Diagnostic Data), screenshots, precise steps for reproducing the issue and a runnable code/project sample if needed.
For urgent inquiries, please use Help | Contact Support in the IDE.