Member since
02-27-2020
173
Posts
42
Kudos Received
48
Solutions
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 1856 | 11-29-2023 01:16 PM | |
| 2351 | 10-27-2023 04:29 PM | |
| 1883 | 07-07-2023 10:20 AM | |
| 3879 | 03-21-2023 08:35 AM | |
| 1342 | 01-25-2023 08:50 PM |
07-13-2021
10:42 AM
Hi @Anyy , Your SQL statement seems to be malformed. You have "from" keyword duplicated. Please fix and try running again. If that helps, please accept as solution. Regards, Alex
... View more
07-08-2021
03:03 PM
1 Kudo
Strange.... As a test can you replace your hard-coded toppic name with something like ${tableName} or just try a different hardcoded string and see if that gets you further along. Not saying that's a solution, but trying to eliminate causes. Also, you mentioned you've implemented other flows already. Could it be that the topic name BUBB-MX_ALL_SOFT is already taken in your kafka cluster and thats why goldengate handler can't create the topic (though I would expect it to just write to the existing topic, instead of throwing an error). I also found this on Oracle site that may have your answer. You'll need an Oracle account to look if there is a solution though. https://support.oracle.com/knowledge/Middleware/2512462_1.html Could this also be an encoding or trailing character issue in the props file between Unix and AIX? Overall this sounds like a GoldenGate error that may be better answered by Oracle community. Regards, Alex
... View more
07-08-2021
02:24 PM
Hi @roshanbi , You can simply put your sqoop command in a shell file and then have Cron run that script according to your desired schedule (depending on how frequently you expect the data to be updated in the Oracle source table). Alternatively, you can use Oozie to orchestrate the running of the sqoop job. Regards, Alex
... View more
06-23-2021
05:32 AM
@roshanbi, have you resolved your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.
... View more
06-23-2021
05:31 AM
@roshanbi, have you resolved your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.
... View more
06-21-2021
01:36 AM
Hi @sakitha Seems to be a known issue. Is the topic whitelist is set to " * " ? Can you please try with dot - " .*" Let us know if that works for you. Regards, ~ If the above answers your questions. Please give a thumbs up and mark the post as accept as solution.
... View more
06-18-2021
01:26 PM
Yes, ReplaceText processor helps. First I convert to csv with regular pipe as delimiter, and after that I replace it with broken pipe. Thanks!
... View more
06-17-2021
01:35 PM
Hi @drgenious , I believe this is possible by providing impala-shell with the following parameter: impala-shell -f /path/ --query_option='mem_limit=3gb' Let me know if that works. Regards, Alex
... View more
06-14-2021
09:55 PM
You are not doing anything wrong. These are warnings, not necessarily errors. Please see this discussion for how to get rid of them, if that's what you are aiming for: https://community.cloudera.com/t5/Support-Questions/Hive-CLI-session-warnings/td-p/242988
... View more