Imported with perfect preview but 0 rows retrieved
After I connected with my azure server
I found it good to upload one csv file named TradingData
But as for another file it doesnt show any error but some unexpected dissapearing comes into being
This file shows perfect preview when i decide to import it
but shows 0 rows retrieved somehow
I dont know why
Hope to solve this problem
Please sign in to leave a comment.
Hi Wang Ye,
What is your current DataGrip version? Am I correct that when you run import data, a new table is created, but the records are not being added? Do you get any errors? Is there anything written to the error log you have specified under Write Errors to File? Can you attach a sample of records so we can test it on our end?
Hi I downloaded recommended version just few days ago, I think it's 2023.1
I sovled this problem by setting null value text as '\N' instead of empty string
Dont know why it occured but i finally found the way solve it
And another problem is that: it shows '???' instead of showing Chinese character in the preview window. So I want to know whether its the problem of azure database or the problem of my datagrip
By the way, could you tell me how to close a solved issue and delete it forever? As this is my first question actually dont know much about functions on my current webpage.
I mean, in preview window it's good to see those special characters.
But after import and uploaded, it returns back only '???' substuting all of my varchar values
I dont know why and wot happened
Could you send us a sample of your file containing records with special characters? We'll have a look and see if we can reproduce this behavior.
Sure.
It was provided by Optiver in their holding competition named ReadyTraderGo.
Here is the datasource(the data I used):
https://docs.google.com/spreadsheets/d/1kdiQxUC7f3UPTxYchkVyFhJXOxKpwQhCVEHdPTKFF1Y/edit?usp=sharing
And here is the copyright statement:
Im not sure whether it will be modified during the process of uploading onto cloud or database server
But I just uploaded it directly, without any modification.
uploads.jetbrains.com/