adhocshare Blog

0

Sqoop – Data import & export

Data import using Sqoop Teradata example $ sqoop import –connect jdbc:teradata://server_name/DATABASE=db1,LOGMECH=LDAP,CHARSET=UTF8 –driver “com.teradata.jdbc.TeraDriver” –username <user1> –password <password1> –query “select a.*, b.* from a inner join b on a.a_id=b.a_id where \$CONDITIONS AND a.f1 in (‘A’,’B’,’C’) group by 1” –null-string ‘\\N’ –null-non-string...

0

RaspberryPi

Basic Steps Increase swap partition $ less /etc/dphys-swapfile $ ll /var/swap -rw——— 1 root 100M Aug 20 06:58 /var/swap $ sudo dphys-swapfile swapoff $ sudo vi /etc/dphys-swapfile # add below line for 2GB swap partition CONF_SWAPSIZE=2048 $ sudo dphys-swapfile setup...

0

Extracting table and column names from SQL query

(Not original article) sql-metadata is a Python library that uses a tokenized query returned by python-sqlparse and generates query metadata. This metadata can return column and table names from your supplied SQL query. Here are a couple of example from the sql-metadata github readme:...

0

MacOS tips

Hide a user account in MacOS https://support.apple.com/en-us/HT203998 https://www.reddit.com/r/macsysadmin/comments/emxph7/catalina_create_a_hidden_user/ https://github.com/gregneagle/pycreateuserpkg Creating user account https://apple.stackexchange.com/questions/226073/how-do-i-create-user-accounts-from-the-terminal-in-mac-os-x-10-11 https://sterlingit.com.au/how-to-create-a-user-or-admin-user-in-osx-apple-mac-via-terminal-commands-in-9-simple-steps/ https://mackeeper.com/blog/post/356-using-various-types-of-user-accounts-on-mac/   Find files created or modified by an installer http://hints.macworld.com/article.php?story=20091223115101622   Take backup of startup entries I’d take a before and after snapshot to identify...

0

JMeter test plan automation

This automation script runs JMeter test plan with multiple input files specified by JMeter. It also has ability to send email before working on an input file and once the input file processing is complete. This is a working attempt...

0

Apache JMeter user.properties file

JMeter user properties file Stashing my jmeter user.properties file settings 😉   command-line > bin/jmeter.bat -n -t “project\Test Plan.jmx” -l “project\output_results\testresults.jtl”   user.properties jmeter.save.saveservice.output_format=xml jmeter.save.saveservice.url=true jmeter.save.saveservice.samplerData=true jmeter.save.saveservice.requestHeaders=true jmeter.save.saveservice.response_code=true jmeter.save.saveservice.response_data=true jmeter.save.saveservice.responseHeaders=true jmeter.save.saveservice.response_message=true jmeter.save.saveservice.thread_name=true jmeter.save.saveservice.time=true jmeter.save.saveservice.latency=true jmeter.save.saveservice.bytes=true jmeter.save.saveservice.hostname=true jmeter.save.saveservice.label=true jmeter.save.saveservice.data_type=true jmeter.save.saveservice.assertions=true jmeter.save.saveservice.assertion_results_failure_message=true...

0

WSL2 configuration

X11 forwarding on WSL2 More info here ~/.bashrc export DISPLAY=$(awk ‘/nameserver / {print $2; exit}’ /etc/resolv.conf 2>/dev/null):0 export LIBGL_ALWAYS_INDIRECT=1   Windows links for linux apps in WSL Adds linux GUI application menu to a windows toolbar https://github.com/cascadium/wsl-windows-toolbar-launcher Related posts: Access...

0

Hadoop streaming with Python

Want to write a Hadoop program in less than 5 minutes? Get in here for a quick check on how it’s done. We use Python and Hadoop streaming to complete the task.