DSXchange

Hi everybody. I need to find a solution to read a complex file, delimited by ';'. Imagine the following layout: Document;QuantityPhone;PhoneNumber;PhoneNumberArea;QuantityEmail;Email;EmailStatus 111111;1;8888-8888;11;1;test@test.com;Valid 222222;2;7777-7777;11;6666-6666;11;1;test@test.com;Valid 3333...

It is so weird, man. We think that it might be the Java version. But when I set JAVA_HOME variable at the job, sometimes it works at the first running. However, the other result executions are wrong. When I copy the job and execute it for the first time, it works. (the following executions record th...

ray.wurlod wrote:Slightly off topic; I've been doing a little work with the Snowflake Connector in version 11.7, and it supports orc partitioning.

So the technology is in there. Joyce has found that (in v11.5 anyw ...

Ray,
Your post was truncated.
:/

Could you copy the last part?
Thank you so much.

Hello.

Did you find any solution for this issue?
I read txt file from HDFS using File Connector and have the same problem.
Actually most of times, I just rerun and it works perfectly - without any other action.

Thank you so much.
Joyce

It didnt work here, so I let the solution like initially: I split the positional file cutting columns inside transformer.
Unfortunately, just a workaround for now.

Hi Ray,
Could you help me?

Tks in advance.

narasimha wrote:The below should work for you. Note the semi-colons.

Code: Select all

BEGIN DBMS_STATS.gather_table_stats(XXXXXXX); END;

This approach worked fine to me! (the only one)

Thank you so much.

Oh nice, Ray. I am still having problems. Actually I read that you can configure the properties of the 'File Connector' the way it can understand the fixed width of the fields: * File format: implicit * Record definition: Delimited String * Definition source: <name>:<definition>[length] Between each...

Did you mean... in a transformer, as I did?
Cause I was thinking about solve it through File Connector only.

Hi everybody. I am using 'File Connector' object to read txt files from HDFS. but some of them are not delimited, fields are positionals. Example: JoyceRecacho34 years oldBrasil In other words, it would be like: Field1: Row[1,12] Field2: Row[13,12] Field1: Row[25,6] ======= I noticed that using the ...

Ma Gosh, you are completely right.
It makes all sense.

Now it works ...
The action was right, but to the wrong user.

Thank you so much!!!

Sorry guys.

This approach of pointing to 'Conductor Node Name' at the advanced sheet only worked out using ODBC Connector.
Actually we are trying to figure out what happens when use JDBC Connector.

As a Workaround, we are using ODBC for now.
Unfortunately we do not have the solution yet.

Thanks,

Tried, but failed.
:/

Sorry, my fault.
I was talking about the dsjob command.

Guys!

The dscmdexport worked!
Actually it was not necessary the domain, only the host.
Since we are working in a Cloud environment, i just informed the wrong value for host. My fault!
:/

But now using the right host in the dsjob comand to list the projects, the issue below still happens.