Member since
01-15-2021
4
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
995 | 01-19-2021 01:53 PM |
07-19-2021
09:21 AM
Hi Asis, Here is the info. CDH version : CDH-7.1.5 Scripture : its just a directory I created under db. Error: Error while compiling statement: FAILED: SemanticException Unable to load data to destination table. Error: The file that you are trying to load does not match the file format of the destination table. Please let me know if you need more information. Thanks, Sai
... View more
07-16-2021
11:47 AM
Hello, I am trying to load bmp image data to hive and getting below error. I went through many past discussions but didn't find an exact solution to implement. Appreciate your help in solving this. Steps I followed. 1: Copied the images to HDFS 2: Created a table with a column Binary 3: Load using data in path. Error: Error while compiling statement: FAILED: SemanticException Unable to load data to destination table. Error: The file that you are trying to load does not match the file format of the destination table. My scripts: create table wrk_image (id int , filename STRING , data BINARY ); load data inpath '/warehouse/tablespace/external/hive/cadt.db/scriptpro/' into table wrk_image;
... View more
Labels:
- Labels:
-
Apache Hive
01-19-2021
01:53 PM
changing the code to for loop worked for line in `hdfs dfs -cat /d/dl/rlsolutions/code/oozie-workflows/rl_solutions/hiveScripts/tables.txt` do tablename=`echo $line | cut -d'.' -f2` sqoop import --connect "jdbc:sqlserver://pppppp:1433;database=xxxxxxxx" --username yyyyyyyyy--password '$$$$$$$' --table $tablename --target-dir hdfs://nameservice1/d/dl/rlsolutions/raw/$tablename -m 1 --as-avrodatafile done
... View more
01-15-2021
10:45 AM
Hello,
I am new to CDH and excuse if its a simple or an easy mistake.
I have shell action in oozie which is failing to read a file.
I have simple wrapper script, reading a file and passing the value in file to the next step, but its failing saying file or directory not exist. I could read/see the same file in server.
Really appreicate your help on this.
below is my script
#!/bin/bash
#to test a sample sqoop script
while read line;
do tablename=`echo $line | cut -d'.' -f2` sqoop import --connect "jdbc:sqlserver://ppppppp:1433;database=yyyy" --username userid --password '******' --table $tablename --target-dir hdfs://nameservice1/d/dl/rlsolutions/raw/{$tablename} -m 1 --as-avrodatafile
done < /d/dl/rlsolutions/code/oozie-workflows/rl_solutions/hiveScripts/tables.txt
error:
./sample3.sh: line 10: /d/dl/rlsolutions/code/oozie-workflows/rl_solutions/hiveScripts/tables.txt: No such file or directory
... View more
Labels: