Member since
04-11-2016
535
Posts
148
Kudos Received
77
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
9094 | 09-17-2018 06:33 AM | |
2375 | 08-29-2018 07:48 AM | |
3367 | 08-28-2018 12:38 PM | |
2858 | 08-03-2018 05:42 AM | |
2580 | 07-27-2018 04:00 PM |
02-03-2017
02:27 AM
3 Kudos
@Praveen Singh
Sql Server does not support Windows authentication with traditional sqljdbc4.jar on UNIX flavours. Try the following steps and jtds driver: 1) Download the jtds driver from: https://sourceforge.net/projects/jtds/files/ (find the FAQ on jtds at http://jtds.sourceforge.net/faq.html)
2) Copy jtds files to sqoop lib
3) Use the following connection string template to modify according to your environment and connect: sqoop export --connect "jdbc:jtds:sqlserver://IE11WIN7:1433;useNTLMv2=true;domain=IE11WIN7;databaseName=default_db" --table "test_table_view" --hcatalog-database default --hcatalog-table t1 --columns col2,col3 --connection-manager org.apache.sqoop.manager.SQLServerManager --driver net.sourceforge.jtds.jdbc.Driver --username IEUser --password 'Passw0rd!' --update-mode allowinsert --verbose
... View more
01-24-2017
06:01 PM
Hi @suresh krish Check if there are any localhost entries under Ranger configs from Ambari and change to appropriate hostname and also, check if HDFS plugin is correctly installed with all necessary access.
... View more
01-17-2017
05:57 PM
1 Kudo
@MPH Yes, you can change the SSH port as below:
... View more
01-11-2017
08:27 PM
@ed day Could you check the value for property 'tez.task.resource.memory.mb'? And try increasing the value of the property tez.task.resource.memory.mb=2048 and check.
... View more
01-05-2017
04:34 PM
@Prasant Kesavakumaran Please mark the answer to close the discussion.
... View more
01-03-2017
05:37 PM
@Prasant Kesavakumaran The ambari-server restart is to be done from the command line, there is no UI option for the same.
... View more
01-03-2017
05:33 PM
The limitation of display of 5000 tables is due to dbms.py script under Hue, below is the snippet of the script: def get_tables(self, database='default', table_names='*'):
hql = "SHOW TABLES IN %s '%s'" % (database, table_names) # self.client.get_tables(database, table_names) is too slow
query = hql_query(hql)
handle = self.execute_and_wait(query, timeout_sec=15.0)
if handle:
result = self.fetch(handle, rows=5000)
self.close(handle)
return [name for table in result.rows() for name in table]
else:
return []
To increase the number of the tables displayed in Hue. Please do the following: 1. cp /usr/lib/hue/apps/beeswax/src/beeswax/server/dbms.py /tmp 2. Stop Hue service as 'service hue stop'. 3. Edit /usr/lib/hue/apps/beeswax/src/beeswax/server/dbms.py to change the rows value to 8000. if handle:
result = self.fetch(handle, rows=8000) --> This value needs to be changed.
self.close(handle)
return [name for table in result.rows() for name in table]
else:
return []
4. Restart hue as 'service hue restart'.
... View more
Labels:
01-03-2017
11:01 AM
@Prasant Kesavakumaran There is known issue in Ambari 2.2 which is addressed in latest versions. Try restarting Ambari server as below and then check: ambari-server restart
... View more
01-03-2017
09:59 AM
1 Kudo
@Asier Gomez Adding to my previous reply, check if the directory /user/admin exists under HDFS. If not, do the following: su - hdfs hdfs dfs -mkdir /user/admin hdfs dfs -chown -R admin:hdfs /user/admin Then, try running the query again.
... View more