Dear Sir, i want to enter python calculated values which are saved in df4 should get stored a column of ''per" per is name of column in hive table . df2 = pd.read_sql("SELECT * FROM ggg where clientcode='55'", conn) this is how i am reading the data how to write df4  python calculated values in "per" column of hive table.  ... View more

QUERY: sqoop import--connect 'jdbc:sqlserver'--username 'sa' -P--query "select * from dlyprice where $CONDITIONS AND `date`= '2019-11-08'"--split-by `date--target-dir /home/hduser2 -m 2 ERROR: getting this error how to get rid of this friends -- please help 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Error parsing arguments for import: 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: Nov 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: 11 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: 11:59:30 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: IST 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: 2019 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: --target-dir 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: home/hduser2/ 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: --append 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: --num-mappers 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: 2 ... View more

getting this error  how to get rid of this friends -- please help 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Error parsing arguments for import: 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: Nov 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: 11 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: 11:59:30 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: IST 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: 2019 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: --target-dir 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: home/hduser2/ 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: --append 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: --num-mappers 19/11/11 11:59:31 ERROR tool.BaseSqoopTool: Unrecognized argument: 2 ... View more

Dear Sir, We are trying to merge two tables and In this date datatype timestamp when I use the date values are shown null and when I use date string they are shown properly And merge operation doesn't happen. ... View more

SC_CODE DATE CO_CODE HIGH LOW OPEN CLOSE VOLUME NO_TRADES NET_TURNOV DMCAP Return Factor TTMPE YEPE FLAG 5004322 10/25/2019 3.0 1526.75 1501.05 1520.05 1517.95 51681.0 1368.0 7.8151398E7 28505.17 -0.052674897 1.0 23.76 18.93 A 5000022 10/25/2019 5.0 174.0 162.15 172.0 164.55 7661.0 1264.0 1275450.0 5589.22 -3.376394598 1.0 33.49 63.07 A 5008722 10/25/2019 73.0 184.2 175.2 182.3 181.2 114897.0 731.0 2.0801958E7 10365.55 -0.275178866 1.0 17.29 14.04 A 5004755 10/25/2019 3.0 76.9 73.15 75.9 74.65 2052480.0 3453.0 1.52315554E8 21913.71 -1.582069875 1.0 21.89 11.02 A and thedatatypesare mentioned down Accept as Solution   ... View more

sc_code string date string co_code double high double low double open double close double volume double no_trades double net_turnov double dmcap double return double factor double ttmpe double yepe double flag string   5004322 10/25/2019 3.0 1526.75 1501.05 1520.05 1517.95 51681.0 1368.0 7.8151398E7 28505.17 -0.052674897 1.0 23.76 18.93 A 5000022 10/25/2019 5.0 174.0 162.15 172.0 164.55 7661.0 1264.0 1275450.0 5589.22 -3.376394598 1.0 33.49 63.07 A 5008722 10/25/2019 73.0 184.2 175.2 182.3 181.2 114897.0 731.0 2.0801958E7 10365.55 -0.275178866 1.0 17.29 14.04 A 5004755 10/25/2019 3.0 76.9 73.15 75.9 74.65 2052480.0 3453.0 1.52315554E8 21913.71 -1.582069875 1.0 21.89 11.02 A ... View more