These are chat archives for araiho/pecan

2nd
Dec 2015
Ann Raiho
@araiho
Dec 02 2015 16:41
okay now LINKAGES is definitely working. I added some more outputs too! I
@mdietze I'm trying to get the MIP runs for Christy. I think they might take awhile because of all the spp and years that are going to go into them, so I want to get them going before I fix the kf code
but i still can't get the db query to work
This is what a line of code looks like for me right now
bety-# SELECT * from ref_species
but nothing happens
Michael Dietze
@mdietze
Dec 02 2015 16:45
I get tons of output from the same command. Could you post exactly what you're using to login and then an EXACT cut and past of the output
Ann Raiho
@araiho
Dec 02 2015 16:46

ESC303741:~ paleolab$ ssh araiho@geo.bu.edu
araiho@geo.bu.edu's password:
Last login: Wed Dec 2 10:56:53 2015 from 108.178.244.178


      This machine is governed by the University policy on ethics.
        http://www.bu.edu/tech/about/policies/computing-ethics/

               This machine is owned and administered by
                           Boston University.

See the Research Computing web site for more information about our facilities.
http://www.bu.edu/tech/about/research/

                For Cluster specific documentation see:
        http://www.bu.edu/tech/about/research/computation/scc/

    Please send questions and report problems to "help@scc.bu.edu".

[araiho@geo ~]$ ssh araiho@test-pecan.bu.edu
araiho@test-pecan.bu.edu's password:
Last login: Wed Dec 2 10:57:01 2015 from geo.bu.edu

Use of Boston University computing facilities is governed
by the BU Conditions of Use and Policy on Computing Ethics.
See http://www.bu.edu/tech/policies/computing-ethics/

[araiho@test-pecan ~]$ psql -U bety -d bety -h psql-pecan.bu.edu
psql (8.4.20, server 9.3.9)
WARNING: psql version 8.4, server version 9.3.
Some psql features might not work.
Type "help" for help.

bety=# SELECT * from ref_species

Michael Dietze
@mdietze
Dec 02 2015 16:47
@araiho you're not getting output because you're logging into BETY not FIA
psql -U bety -d fia5 -h psql-pecan.bu.edu
Ann Raiho
@araiho
Dec 02 2015 16:47
NO! sorry
wait still not working

[araiho@test-pecan ~]$ psql -U bety -d fia5 -h psql-pecan.bu.edu
psql (8.4.20, server 9.3.9)
WARNING: psql version 8.4, server version 9.3.
Some psql features might not work.
Type "help" for help.

fia5=# SELECT * from ref_species
fia5-#

@mdietze do I need to be logged in just from geo instead of test-pecan?
Michael Dietze
@mdietze
Dec 02 2015 16:54
notice the change in prompt from fia5= to fia5-
this means that you are continuing the current line
as i mentioned a few days ago, i think you're forgetting your semicolon ;
just type ; to finish the line
Ann Raiho
@araiho
Dec 02 2015 18:37
@mdietze so i think i almost have it, but it's taking forever. So, i must be doing something wrong.
select ref_species.genus, ref_species.species, plot.lat, plot.lon, sum(dia^2) as BA from tree
left join ref_species on tree.spcd=ref_species.spcd
left join plot on tree.plot=plot.plot
WHERE plot.lat > 42 and plot.lat < 43 and plot.lon < -85 and plot.lon > -86
group by ref_species.genus, ref_species.species, plot.lat, plot.lon
order by BA DESC;
by a long time i mean 10min+
it's still going