Member since
11-29-2016
17
Posts
8
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
115 | 07-18-2024 11:46 PM |
07-18-2024
11:46 PM
1 Kudo
Thank you for the comments. we fixed the issue. issue is firewall rules not granted correctly Thank you!
... View more
07-17-2024
10:03 PM
1 Kudo
Thank you for the updated. but Oracle native sqlplus already enabled.
... View more
07-17-2024
10:55 AM
Unable to execute the Sqoop command after configuring the existing environment into the new environment. we are using Sqoop import/export command to get the data from other DB to the HADOOP. But it's failed with following error. But we can do eval command and list command for same DB. Error: java.lang.RuntimeException: java.sql.SQLException: ORA-12541: Cannot connect. No listener at host prxd10-scan.intranet.slt.com.lk port 1521. (CONNECTION_ID=fnQPj6XGQbKYLTFy6NYkAA==) https://docs.oracle.com/error-help/db/ora-12541/ but we are doing some Sqoop job with HADOOP and other DBs. please help me!
... View more
03-19-2024
10:39 PM
Hi everyone, I need to create HUE table separating "|" for insert like following values into table with removing all not required "" "94112605011"|"DEFAULT"|"FTTH_WEB FAMILY PLUS!PDL&Ec5@1706725800;94112605011;1704047400"|"COUNTER"|"u"|"0E-12"|"2023-12-31 18:30:00.000000"|"2024-01-31 18:30:00.000000"|"0"|"{""data"":{""o"":{""-t"":""ECS_BalanceContextInfo"",""m"":[{""-c"":""57a2"",""-v"":""1"",""a"":[{""-n"":""unitType"",""v"":{""-s"":""VOLUME""}},{""-n"":""offerId"",""v"":{""-s"":""15""}},{""-n"":""offerName"",""v"":{""-s"":""FTTH_WEB FAMILY PLUS""}},{""-n"":""offerQuota"",""v"":{""-s"":""42949672960""}},{""-n"":""quotaThreshold"",""v"":{""-s"":""0""}}]}],""o"":[{""-t"":""ECS_BalanceContextInfoBase"",""m"":[{""-c"":""5136"",""-v"":""1""},{""-c"":""8d18"",""-v"":""2"",""a"":[{""-n"":""subscriptionId"",""v"":{""-s"":""9411260501111152164097540010""}}]}]},{""-t"":""ECS""},{""-t"":""AVS"",""m"":[{""-c"":""e3a0"",""-v"":""1""}]}]}}}"|"{""a"":[""0""]}"|"BYTES"|"0E-12" i HAVE USED FOLLOWING COMMAND CREATE TABLE slt.OCS_BALANCE(SUBSCRIBERID STRING,PURSEID STRING,BALANCEID STRING,BALANCETYPE STRING,BALANCEFLAGS STRING,CREDITLIMIT STRING,EFFECTIVEDATE STRING,EXPIRYDATE STRING,PRIORITY STRING,CONTEXTINFO STRING,ROLLOVERAMOUNT STRING,UNITTYPE STRING,THRESHOLDALTERATION STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' WITH SERDEPROPERTIES ('serialization.format'=',', 'field.delim'=',') STORED AS TEXTFILE LOCATION '/temp/OCS_BALANCEVALUE'; Please guide me to create correct table
... View more
Labels:
- Labels:
-
Apache Hive
-
Cloudera Hue
03-18-2024
03:47 AM
1 Kudo
Thank you!
... View more
03-14-2024
11:28 PM
1 Kudo
Rename of the HADOOP/HUE table name Hi everyone, I need to rename the table name in HUE. i used following command. ALTER TABLE db.table1 RENAME TO db.table2; Please let me know the correct way to rename the table without any issue. Thank you.
... View more
Labels:
- Labels:
-
Cloudera Hue
09-22-2023
02:05 AM
Hi every one, How to find the standard cloudera ranger policy update for specific users related to the specific folder path, tables and etc... Thank you!!!
... View more
Labels:
06-29-2023
10:26 PM
Great... Thank you very much! it's working....
... View more
06-25-2023
09:55 PM
Hi,@mszurap Thanks for the reply.! I not got any errors after end the commands.it was just printing the result as the following. +-----------+ | _c0 | +-----------+ | 84300000 | +-----------+ I need to get the record count into the variable of "count" as following count=84300000
... View more