Project operations

use <project_name>;

• Enters a specific project. After you enter the project, you can manage all objects in the project. You must have access permissions on the project.
• If the project does not exist or the current user does not belong to the project, an error is returned.

• Enter a specific project.

  -- Enter the my_project_test project. The user has access permissions on this project.
  odps @ my_project>use my_project_test;  

• Access the objects in the project.

  -- Query the test_src table in the my_project_test project.
  odps @ my_project_test>SELECT * FROM test_src;

  MaxCompute automatically searches for the table under the my_project_test project. If this table exists, data in the table is returned. If this table does not exist, the session returns an exception and exits.
• Access objects in another project. To do this, you must specify the project name.

  -- Access the test_src table in another project my_project2 from the my_project_test project.
  odps @ my_project_test>select * from my_project2.test_src;

list projects;

setproject <KEY>=<VALUE>;

• Sets project properties when specifying <KEY>=<VALUE>. The following example shows how to allow a full table scan.

  setproject odps.sql.allow.fullscan=true;

• Displays the project properties if <KEY>=<VALUE> is not specified.

  -- Displays the parameters set by running setproject.
  setproject; 

• To set a whitelist of IP addresses that are authorized to access projects over the Internet, run the following command:

  setproject odps.security.ip.whitelist= IP Address

• To set a whitelist of IP addresses that are authorized to access projects over a VPC, run the following command:

  setproject odps.security.vpc.whitelist= RegionID_VPCID[IP address]

• After an IP address whitelist is configured for a project, only IP addresses, for example, the outbound IP addresses of the odpscmd client or SDK, in the whitelist are authorized to access the project.
• After you set the IP address whitelist, you need to wait five minutes before it takes effect.

• IP Address: indicates an IP address. In a VPC, it is the IP address of the VPC.
  Whitelists support IPv6 addresses. IP addresses in whitelists can be expressed in the following formats:

  • IP addresses, for example, 101.132.236.134 and FE80:0202:B3FF:FE1E:8329.
  • CIDR blocks, for example, 100.116.0.0/16 and FE80:0101:4567:F456:0202:B3FF:1111:1111/126.
  • IP address ranges, for example, 101.132.236.134 - 101.132.236.144 and FE80:0101:4567:F456:0202:B3FF:FE1E:8330 - FE80:0101:4567:F456:0202:B3FF:FE1E:8331.

  The IP addresses in the preceding three formats can be written in the same command and are separated with commas (,).
• ReigonID: indicates the ID of the region to which the VPC belongs. The following table lists the mappings between regions and region IDs.

  Region	Region ID
  China (Zhangjiakou-Beijing Winter Olympics)	cn-zhangjiakou
  China (Beijing)	cn-beijing
  China (Shenzhen)	cn-shenzhen
  China (Chengdu)	cn-chengdu
  China (Shanghai)	cn-shanghai
  China (Hangzhou)	cn-hangzhou
  Shanghai Tower	cn
  China (Hong Kong)	cn-hongkong
  Singapore (Singapore)	ap-southeast-1
  Australia (Sydney)	ap-southeast-2
  Malaysia (Kuala Lumpur)	ap-southeast-3
  Indonesia (Jakarta)	ap-southeast-5
  Japan (Tokyo)	ap-northeast-1
  Germany (Frankfurt)	eu-central-1
  US (Silicon Valley)	us-west-1
  US (Virginia)	us-east-1
  India (Mumbai)	ap-south-1
  UAE (Dubai)	me-east-1
  UK (London)	eu-west-1

• VPCID: indicates the ID of a VPC.

• Use a command line tool to set an IP address whitelist for the Internet.

  setproject odps.security.ip.whitelist=101.132.236.134,100.116.0.0/16,101.132.236.134-101.132.236.144;

• Use a command line tool to set an IP address whitelist for a VPC. In the following example, the region IDs are cn-beijing and cn-chengdu. These regions correspond to VPC IDs 154286 and 461230, respectively.

  setproject odps.security.vpc.whitelist=cn-beijing_154286[192.168.10.102,192.168.0.10],cn-chengdu_461230[172.16.1.100,172.16.30.200];

• When a whitelist is cleared for a project, MaxCompute considers that whitelist disabled for the project.

  -- Disable an IP address whitelist for the Internet.
  setproject odps.security.ip.whitelist=;
  -- Disable an IP address whitelist for a VPC.
  setproject odps.security.vpc.whitelist=;