Salary Survey

Indeed has a cool salary tool I just noticed. You can find the average salary associated with some reasonably detailed queries. Here is a comparison of the salary of marketing data analysts across cities:

data analyst marketing in Boston, MA $92,000
data analyst marketing in Denver, CO $72,000
data analyst marketing in Arlington, VA $92,000
data analyst marketing in San Diego, CA $77,000
data analyst marketing in Mountain View, CA $101,000
data analyst marketing in Chicago, IL $84,000
data analyst marketing in New York, NY $101,000
data analyst marketing in Seattle, WA $72,000
data analyst marketing in Dallas, TX $79,000
data analyst marketing in Atlanta, GA $86,000
data analyst marketing in Portland, OR $68,000
data analyst marketing in Los Angeles, CA $83,000

View Larger Salary Graph

And here we are with Hadoop:

hadoop in New York, NY $129,000
hadoop in Arlington, VA $118,000
hadoop in Boston, MA $119,000
hadoop in Chicago, IL $109,000
hadoop in Atlanta, GA $110,000
hadoop in Palo Alto, CA $131,000
hadoop in San Diego, CA $99,000

View Larger Salary Graph

Hex in Netezza

I needed to convert Hex strings to integers in Netezza. Here is how I did it:

Put a file called hex2dec.py at /nz/export/ae/applications/system/admin/hex2dec.py

with contents:

import nzae

class Hex2DecUdfAe(nzae.Ae):

    def _getFunctionResult(self, row):

        hexString, base = row

        return int(hexString, base)

Hex2DecUdfAe.run()

then register it with

[nz@dw01 ~/scripts]/nz/export/ae/utilities/bin/register_ae --language python --version 1 --template udf --exe hex2dec.py --sig "hex2dec(varchar(255), int4)" --return int4

Call it like this:

select system..hex2dec('101', 2), system..hex2dec('A1', 16);

Base conversion in Netezza

In Netezza, I need to convert strings in binary or in hex to base 10. Here is how i did it:

Put a file called hex2dec.py at /nz/export/ae/applications/system/admin/hex2dec.py

with contents:

import nzae

class Hex2DecUdfAe(nzae.Ae):

    def _getFunctionResult(self, row):

        hexString, base = row

        return int(hexString, base)

Hex2DecUdfAe.run()

then register it with

[nz@dw01 ~/scripts]/nz/export/ae/utilities/bin/register_ae --language python --version 1 --template udf --exe hex2dec.py --sig "hex2dec(varchar(255), int4)" --return int4

Call it like this:

select system..hex2dec('101', 2)