Advanced Amazon Redshift: Performance Tuning Reviews
233 reviews
The Windows EC2 didn't have pip installed along with python 2.7.6 (there was no Scripts directory when doing step 45). I had to download and install pip manually so I could install the python modules.
Tim C. · Reviewed أكثر من 6 سنوات ago
Problem with getting Python running. Logged as ticket by AWS T&C team.
Chris S. · Reviewed أكثر من 6 سنوات ago
Jeroen M. · Reviewed أكثر من 6 سنوات ago
Arun K. · Reviewed أكثر من 6 سنوات ago
This lab is full of inaccuracies 1) No C:\Python27\scripts 2) Downloaded get-pip.py via https://bootstrap.pypa.io/get-pip.py (had to troubleshoot) 3) 2nd Explain plan does not match what is shown in the docs 4) Show the create SQL for the tables so that we know the distribution ond order keys 5) This took less than a minute with no modifications: C:\Python27>python.exe analyzecompression.py --db redshiftdemo --db-user awsuser --db-host qls-1914787-f7dfda7318e89e94-redshiftcluster-aa88tih1631j.c9ligqnif0mw.us-west-2.redshift.amazonaws.com --db-port 5439 --analyze-schema public --target-schema public --output-file output.txt --do-execute true Password <awsuser>: -- [2672] Connected to qls-1914787-f7dfda7318e89e94-redshiftcluster-aa88tih1631j.c9ligqnif0mw.us-west-2.redshift.amazonaws.com:5439:redshiftdemo as awsuser -- [2672] Analyzing Schema 'public' for Columnar Encoding Optimisations with 1 Threads... -- [2672] Recommended encoding changes will be applied automatically... -- [2672] Extracting Candidate Table List... -- [2672] Analyzing 7 table(s) which contain allocated data blocks -- [2672] Table region contains 3 unoptimised columns -- [2672] Analyzing Table 'region' -- [2672] Column Encoding resulted in an identical table - no changes will be made -- [2672] Table nation contains 4 unoptimised columns -- [2672] Analyzing Table 'nation' -- [2672] Column Encoding resulted in an identical table - no changes will be made -- [2672] Table customer does not require encoding optimisation -- [2672] Table orders_nodist does not require encoding optimisation -- [2672] Table orders_dist does not require encoding optimisation -- [2672] Table lineitem_nodist does not require encoding optimisation -- [2672] Table lineitem_dist does not require encoding optimisation -- [2672] Performed modification of 0 tables C:\Python27> Due to the inaccurate documentation, rushed through the lab without digesting as much as I had hoped. I hope my assessment helps the lab preparer and fixing the issues. This lab is very important for the success of this course. This lab could use some more time. Maybe, break it into 2 labs. Thanks for listening to me!
pauly l. · Reviewed أكثر من 6 سنوات ago
The information was wrong or out of date. The instances were too slow to finish in one sitting and the differences between the distributions were not explained. This should be expanded into two labs and larger VMs need to be used.
Chad D. · Reviewed أكثر من 6 سنوات ago
pip wasn't available and \Python27\Scripts was missing
Barret N. · Reviewed أكثر من 6 سنوات ago
Needs more time
Todd M. · Reviewed أكثر من 6 سنوات ago
Bruce L. · Reviewed أكثر من 6 سنوات ago
Steven P. · Reviewed أكثر من 6 سنوات ago
Due to no Python/Scripts folder, I couldn't install Python compression function and couldn't execute compression parts.
Taguchi G. · Reviewed أكثر من 6 سنوات ago
pierre m. · Reviewed أكثر من 6 سنوات ago
pip instructions do not work. I had to install pip manually.
Oscar H. · Reviewed أكثر من 6 سنوات ago
Javier C. · Reviewed أكثر من 6 سنوات ago
key有问题,没法打开远程桌面
han c. · Reviewed أكثر من 6 سنوات ago
barely enough time to finish.
Yong R. · Reviewed أكثر من 6 سنوات ago
console won't open.
Yong R. · Reviewed أكثر من 6 سنوات ago
Mani V. · Reviewed أكثر من 6 سنوات ago
Summary: not good and dissappointed. Two parts of the lab confused me and drained a lot of my lab time. The first, which drained the most time, was the switch from the Python27 command line tasks to editing the analyzecompression.py doc. You should make it much more explicit that you are switching to the remote desktop C drive not just assume "C:>Python27" will be understood by all. I was confused for a while and got frustrated. I thought I was opening a Python27 folder using the command prompt. Please make this clearer. The second drain on time came from some syntax issue copying the Redshift endpoint in analyzecompression.py. I missed the inverted commas, but at no point in your notes did you mention the inverted commas. Please amend your texts. Regards, Stuart
Stuart D. · Reviewed أكثر من 6 سنوات ago
Execution plan explanation does not match with the actual query/plan. After WLM reboot, unable to run queries through Worbench.
Quentin R. · Reviewed أكثر من 6 سنوات ago
Mohammed A. · Reviewed أكثر من 6 سنوات ago
Joshua M. · Reviewed أكثر من 6 سنوات ago
Ridge X. · Reviewed أكثر من 6 سنوات ago
David K. · Reviewed أكثر من 6 سنوات ago
good lab
Derek H. · Reviewed أكثر من 6 سنوات ago
We do not ensure the published reviews originate from consumers who have purchased or used the products. Reviews are not verified by Google.